| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> FW: tablespaces ddl extract script
For the board
-----Original Message-----
From: Powell, Mark D
Sent: Wednesday, October 12, 2005 6:34 AM
To: 'sjaffarhussain_at_gmail.com'
Subject: RE: tablespaces ddl extract script
Syed,
You can use a full database export and the imp utility parameter indexfile feature to create you a file with all the source code for the database objects or you can selectively use the dbms_metadata package.
Writing the SQL to generate the public synonyms or to pre-create users is child's play.
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of The Human Fly
Sent: Wednesday, October 12, 2005 6:24 AM
To: Oracle-L Freelists
Subject: tablespaces ddl extract script
Friends,
My mgmt. has decided to move our datawarehouse, around 1.5 TB from AIX
server to HP-SUPERDOM. We are using oracle 9i and only export and import
possible, I believe. This database has around 100 tbs. My planning is
to get ddl of those tablespace exists on AIX to create them on
HP-SUPERDOM server database.
Can any has scripts to extract the ddl of all tablespace with datafile
defination in a database?
Thanking you in advance.
--
Best Regards,
Syed Jaffar Hussain
 |
 |