Home » RDBMS Server » Server Utilities » export from 9i import to 10g (9i to 10g)
export from 9i import to 10g [message #358527] Tue, 11 November 2008 16:18 Go to next message
alexsdba
Messages: 2
Registered: November 2008
Location: NYC
Junior Member
Hi all
I'm trying to import a full database from 9i to 10g.
On 9i I ran:
exp system/pass@mydb FULL=Y FILE=c:\PRDPS_SYSADM_063008.dmp LOG= PRDPS_SYSADM_063008.log OWNER=SYSADM

On 10g i ran:
imp system/pass@mydb FULL=y IGNORE=y FILE=E:\devpsxlr_11_06_2008.dmp LOG=E:\devpsxlr_11_06_2008.log

And now i don't have my users and roles.

Should i remove OWNER=SYSADM in order to copy all users?
Re: export from 9i import to 10g [message #358646 is a reply to message #358527] Wed, 12 November 2008 01:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is wrong you succeeded to do the first step, you can't use FULL and OWNER at the same time:
C:\>exp system/michel FULL=Y FILE=c:\PRDPS_SYSADM_063008.dmp LOG= PRDPS_SYSADM_063008.log OWNER=SYSADM

Export: Release 10.2.0.4.0 - Production on Wed Nov 12 08:07:01 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options
EXP-00026: conflicting modes specified
EXP-00000: Export terminated unsuccessfully

Regards
Michel
Re: export from 9i import to 10g [message #358808 is a reply to message #358527] Wed, 12 November 2008 09:48 Go to previous messageGo to next message
alexsdba
Messages: 2
Registered: November 2008
Location: NYC
Junior Member
I actually did not have FULL=Y in my script and only had OWNER.
I tried to export/import again using FULL=Y and it worked i got all the users and their roles.

Thanks
Re: export from 9i import to 10g [message #358821 is a reply to message #358808] Wed, 12 November 2008 10:15 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How could we answer appropriatly if you post wrong question?
If you export with OWNER you just have user objects and not user definition.
Only FULL=Y gives you users definition.

Regards
Michel
Previous Topic: Import error
Next Topic: Errors in impdp command on oracle 10g database
Goto Forum:
  


Current Time: Sun Dec 11 00:40:13 CST 2016

Total time taken to generate the page: 0.09718 seconds