Clever Geek Handbook

Problems importing SQL script from Oracle 9i to Oracle 10g express

I am currently having a problem while trying to import an Oracle 9i SQL script into my local Oracle 10g Express database. I am trying to import DDL from 9i database to 10g express database. I keep getting "Not Compatible - Your Export File Is Not Supported". Has anyone been able to get this to work? Please let me know what I can do to make this work.

+1


source to share


3 answers


Make sure you export and import with the same version of exp and imp, and also make sure that this version matches the lower version of both databases in your case: 9i.

Maybe you should explicitly specify the path to imp and exp as / path / to / oracle / bin / exp.



Hope this helps Rene

+1


source


Are you trying to run the import utility on a .sql script? Or import the exported file?



If the latter, provisional answers are acceptable. If the former, run the script creation through SQLPLUS, PlsqlDeveloper, TOAD, SQLDeveloper, or whatever you use to run ddl statements.

+1


source


I have successfully imported an Oracle 9 export (created with the "exp" utility) into an Oracle 10 database (using the "imp" utility) thismorning. It worked great.

Can you provide additional information? for example the output of the command you are running, an example file or more details?

0


source






More articles:


All Articles