> Hi Mr.Kaplan,
> 
> I would be thankful to you, if U could tell me how I exp a 7.3 or 7.x 
> database (tables) to 6.0.33 DB.
> 
> I have all methods spec. by oracle.
> ie. run script catexp6.sql and then oracle 7 exp.
> But I am facing problems with character set,
> ie Oracle 6 character set is US7ASCII, whereas 7.x is WEISO...
> Even I have oracle db with US7ASCII character set.
> But no way I could import the data to 6.0
> 
> Thanks in advance
> 
> Padmanabhan
Padmanabhan,

That's a good question. I believe the only way is to change the COMPATIBILITY
parameter in the PFILE file to "6.0.33".
Do this for the 7.x database. Then export and import into the 6.0.33 db.

When it is successfully imported, remove the COMPATIBILITY line in the PFILE.


-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 115+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page Ari Kaplan's Home Page