IMP from EXP with FULL=Y
629826Mar 10 2010 — edited Mar 18 2010Hi all.
I have a full=y export from my 9i peoplesoft db running on windows
I did run catexp.sql in my 9i db before the export:
exp system/pass@nycdb1 FULL=Y GRANTS=y INDEXES=y CONSISTENT=y FILE=E:\backups\nycdb1.dmp LOG=E:\backups\nycdb1.log
I'm importing this to 11g running on OEL 5.2.
Should i run catexp.sql in the 11g db before import?
And also I have about 15 users in the db so does my import have to be done 15 times for each user specifying fromuser touser:
imp system/pass@nycdb11g fromuser=SYSADM touser=SYSADM FILE=/u03/nycdb1.dmp LOG=/u03/IMPORT_nycdb1.LOG
imp system/pass@nycdb11g fromuser=PS touser=PS FILE=/u03/nycdb1.dmp LOG=/u03/IMPORT_nycdb1.LOG
imp system/pass@nycdb11g fromuser=PEOPLE touser=PEOPLE FILE=/u03/nycdb1.dmp LOG=/u03/IMPORT_nycdb1.LOG
...etc
Any help appreciated.
Thank you