Home » RDBMS Server » Server Administration » How to generate "Create tablespace statement" (Oracle 9.2.0.7 on on AIX)
How to generate "Create tablespace statement" [message #354229] Fri, 17 October 2008 02:12 Go to next message
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
Re: How to generate "Create tablespace statement" [message #354242 is a reply to message #354229] Fri, 17 October 2008 02:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes you can do it using the dictionary information but why don't you want to use dbms_metadata.

Regards
Michel

[Updated on: Fri, 17 October 2008 03:00]

Report message to a moderator

Re: How to generate "Create tablespace statement" [message #354395 is a reply to message #354229] Sat, 18 October 2008 06:58 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

export - import with ROWS=N also work.
Re: How to generate "Create tablespace statement" [message #354530 is a reply to message #354229] Mon, 20 October 2008 03:29 Go to previous messageGo to next message
ora110
Messages: 42
Registered: September 2007
Location: China
Member

try this.
SELECT DBMS_METADATA.GET_DDL('TABLESPACE', tablespace_name)
FROM DBA_tablespaces;

Re: How to generate "Create tablespace statement" [message #354534 is a reply to message #354530] Mon, 20 October 2008 03:46 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It seems OP EXCLUDED dbms_metadata as he requested for a way that is SIMILAR to this package.
So I don't think he will try it.

Regards
Michel
Previous Topic: High Water Mark
Next Topic: what are steps to change database name on oracle 9i on linux
Goto Forum:
  


Current Time: Fri Dec 09 19:30:02 CST 2016

Total time taken to generate the page: 0.23747 seconds