OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » export problem

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

export problem [message #226559]

Sun, 25 March 2007 02:22

alzuma
Messages: 46
Registered: July 2006
Location: CA

Member

hi all,

i made an export to my 10g schema (*.dmp)
when i tried to make an import for it on
oracle 9i schema - refused- ??

my question is how to import my dmp file
which taken from 10g to my 9i DB?

Thanks

Report message to a moderator

Re: export problem [message #226565 is a reply to message #226559]

Sun, 25 March 2007 02:41

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

See the answer we gave you in DBA Village.

The next time, search a little bit this question has been answered dozen of times.

Report message to a moderator

Re: export problem [message #226577 is a reply to message #226565]

Sun, 25 March 2007 04:54

alzuma
Messages: 46
Registered: July 2006
Location: CA

Member

thanks ,
but what tool i can use in 10g
i can't install 9i product there .

Report message to a moderator

Re: export problem [message #226581 is a reply to message #226577]

Sun, 25 March 2007 05:14

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Read carefully and try to understand the answer gave in the previous link.

Report message to a moderator

Re: export problem [message #226584 is a reply to message #226559]

Sun, 25 March 2007 05:55

alzuma
Messages: 46
Registered: July 2006
Location: CA

Member

Many thanks

but, what is equal to this option in 9i export command

10g
expdp username/password DUMPFILE=test.dmp CONTENT=METADATA_ONLY

9i
exp username/password FILE=test.dmp CONTENT=METADATA_ONLY

to restrict export without data ?

Report message to a moderator

Re: export problem [message #226585 is a reply to message #226584]

Sun, 25 March 2007 06:19

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Sorry, I said Google and search, I should add "and read documentation".

Just an obvious remark: "expdp" != "exp"
another one "exp help=yes".

Report message to a moderator

Re: export problem [message #226589 is a reply to message #226585]

Sun, 25 March 2007 07:13

orausern
Messages: 826
Registered: December 2005

Senior Member

Please refer the documentation at:
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#i1013164

As mentioned in the table 19-7 "Using Different Releases of Export and Import"
you need to use 'exp' utiilty to export the data from 10g database..so use the exp utility of oracle 9i version to do the export and then import..how do you do this? well connect from the place where u have the 9i export utility to the 10g database and the use the 9i export utility.

Report message to a moderator

Previous Topic:	Importing pocedures funcations packages triggers
Next Topic:	ora-600[6002]

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 12:21:14 CST 2024