How to generate "Create tablespace statement" [message #354229] |
Fri, 17 October 2008 02:12 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
gkodakalla
Messages: 49 Registered: March 2005
|
Member |
|
|
Hi,
we are moving a database from one server to another server.
It is oracle 9.2.0.7 database.
I have around 25 tablespaces in current database. I need to recreate those databases in new database.
Is there any way (Similar to DBMS_METADATA.GET_DDL) which i can use to extract the "Create Tablespace" statement from existing database?
Similarly, i want to extract users,roles and privileges only, not the data.
Thank you
Giridhar
|
|
|
|
|
|
|