|
|
| Re: export/import tablespaces [message #52964 is a reply to message #52963] |
Wed, 21 August 2002 19:35   |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
In Oracle 9i you can just say tablespace= and get all objects in one shot.
For Oracle 8i you have to use transportable tablespaces, which has some constraints as same block size, same OS, etc.
The procedure is as follows:
1. Make the tablespace readonly.
sqlplus> connect sys/manager
sqlplus> alter tablespace test read only;
2. Export the tablespace specifying the TABLESPACES and TRANSPORT_TABLESPACE
clause
C:tmp>exp sys/manager file=tt.dmp tablespaces=test transport_Tablespace=y ......
3. Transfer the meta data export dump file and the copy of the datafile(s) to the target database. (Could be ftp or copy or via cdrom or any other
compatible media)
4. Import the metadata using TABLESPACES, TRANSPORT_TABLESPACE, DATAFILES clause. If more than one datafiles are available then specify all of them comma seperated.
C:>imp system/manager file=tt.dmp TABLESPACES=test TRANSPORT_TABLESPACEe=y DATAFILES=d:oracle8ioradataventuretest01.dbf, d:oracle8ioradataventuretest02.dbf .....
5. Make the tablespace read write, if required, at the target database
sqlplus>connect sys/manager
sqlplus>alter tablespace test read write;
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
| Re: export/import tablespaces [message #52966 is a reply to message #52963] |
Wed, 21 August 2002 22:29 |
fani bachsin
Messages: 4
Registered: August 2002
|
Junior Member |
|
|
hi,
i've tried these steps but it doesn't work well, i think it'll work on nt,
won't it ?
what about on hp-ux ? am i using the same command ?
we have to run this export on testing env, how to specify ?, tks a lot
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
