Home » RDBMS Server » Server Utilities » Data Pumping in Oracle 9i
Data Pumping in Oracle 9i [message #204859] Wed, 22 November 2006 07:21 Go to next message
Bijupm
Messages: 16
Registered: February 2006
Junior Member
Hai,

I am using oracle9i version 9.2.

I want to transport tablespace with data.

i tried it with Exp utility in Oracle9i,but only the structure is exported.

My question is, can I use Expdp utility of Oracle10g in Oracle9i to export tablespace.

Regards,
Biju.

Re: Data Pumping in Oracle 9i [message #204866 is a reply to message #204859] Wed, 22 November 2006 07:38 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi

My question is, can I use Expdp utility of Oracle10g in Oracle9i to export tablespace

You cann't use "expdp" utility in Oracle 9i bcoz it is introduce in Oracle 10g with datapump option.

if you want to move ur database from oracle 9i to oracle 10g. so you can go below procedure.

1. use in oracle 9i original export utiltiy and export ur data.
2. use exp original utitlity in oracle 10g. and export ur data. or you can also use impdp utility in OEM.


i tried it with Exp utility in Oracle9i,but only the structure is exported.


Yes only metadata will be export.

Transport tablespace.
Note : export tablespace is read only mode.
1.exp metadata with transport tablespace.
2. copy datafile from source destination and paste target destination.
3.go another server ( wherever you want to import ur data)
and use > imp cmd and import ur data.



http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96652/ch01.htm#1006961
hope this helps
Taj.
Previous Topic: Export from schema to another schema
Next Topic: How to use SQL Loader
Goto Forum:
  


Current Time: Mon Dec 05 21:35:30 CST 2016

Total time taken to generate the page: 0.09030 seconds