-----Original Message-----
Hi ARI,
I guess I have a silly question for you ....
I had orginally created the tables in personal oracle 8 and now
I need to import the tables to oracle 7 installed in the server.
IS IMPORT TO A LOWER VERSION POSSIBLE FROM A HIGHER VERSION ?
THANKS IN ADVANCE......
gayatri
___________ Reply ___________________________________________
From what I have experienced, the only way to do it is shut down the database,
change the init.ora parameter COMPATIBILITY to the version you have in Oracle7,
start up the database, and do the export. Otherwise make a database link and do
many SQL statements in the Oracle7 database such as:
CREATE TABLE table_a AS SELECT * FROM table_a@ORACLE8DB;
Replace "ORACLE8DB with the name of the Oracle8 database.
Best of luck,
-Ari Kaplan
www.arikaplan.com
Back to Ari Kaplan's Home Page