Home » RDBMS Server » Backup & Recovery » export problem
export problem [message #226559] Sun, 25 March 2007 02:22 Go to next message
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
Re: export problem [message #226565 is a reply to message #226559] Sun, 25 March 2007 02:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: export problem [message #226577 is a reply to message #226565] Sun, 25 March 2007 04:54 Go to previous messageGo to next message
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 .
Re: export problem [message #226581 is a reply to message #226577] Sun, 25 March 2007 05:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Read carefully and try to understand the answer gave in the previous link.
Re: export problem [message #226584 is a reply to message #226559] Sun, 25 March 2007 05:55 Go to previous messageGo to next message
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 ?
Re: export problem [message #226585 is a reply to message #226584] Sun, 25 March 2007 06:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
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".
Re: export problem [message #226589 is a reply to message #226585] Sun, 25 March 2007 07:13 Go to previous message
orausern
Messages: 817
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.

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


Current Time: Fri Dec 09 04:10:59 CST 2016

Total time taken to generate the page: 0.07350 seconds