467,116 Members | 1,135 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,116 developers. It's quick & easy.

Import Problem

I am planning to migrate my oracle database from 8.1.7 to 9i. I done the full database export using the following command.
----------------------------------------------------------------------------
set ORACLE_SID=pp01
set NLS_LANG=american_america.us7ascii
exp db_export/createdmp file=f:\oracle\export\pp01_A.dmp,f:\oracle\export\ pp01_B.dmp,f:\oracle\export\pp01_C.dmp,f:\oracle\e xport\pp01_D.dmp full=y grants=Y indexes=Y rows=y constraints=y compress=n direct=y consistent=y filesize=2g log=f:\oracle\export\exp_pp01.log
exit
----------------------------------------------------------------------------
Database exported without any warnings.

I created oracle 9i database and I want to import the database using above dmp files.
Please send me the script which will import the full database without problems.

Thanks & Best regards,
May 2 '07 #1
  • viewed: 1482
Share:

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by John Roth | last post: by
5 posts views Thread by Steve Holden | last post: by
2 posts views Thread by Panard | last post: by
1 post views Thread by Nick Craig-Wood | last post: by
reply views Thread by Victor Lin | last post: by
5 posts views Thread by Stef Mientki | last post: by
10 posts views Thread by nisp | last post: by
13 posts views Thread by Rafe | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.