OraFAQ Forum: Server Utilities » export from 9i import to 10g

Home » RDBMS Server » Server Utilities » export from 9i import to 10g (9i to 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

export from 9i import to 10g [message #358527]

Tue, 11 November 2008 16:18

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?

Report message to a moderator

Re: export from 9i import to 10g [message #358646 is a reply to message #358527]

Wed, 12 November 2008 01:07

Michel Cadot
Messages: 68647
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

Report message to a moderator

Re: export from 9i import to 10g [message #358808 is a reply to message #358527]

Wed, 12 November 2008 09:48

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

Report message to a moderator

Re: export from 9i import to 10g [message #358821 is a reply to message #358808]

Wed, 12 November 2008 10:15

Michel Cadot
Messages: 68647
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

Report message to a moderator

Previous Topic:	Import error
Next Topic:	Errors in impdp command on oracle 10g database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 01 04:13:15 CDT 2024