| Data Pumping in Oracle 9i [message #204859] |
Wed, 22 November 2006 07:21  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
