OraFAQ Forum: Server Administration » How to generate "Create tablespace statement"

Home » RDBMS Server » Server Administration » How to generate "Create tablespace statement" (Oracle 9.2.0.7 on on AIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to generate "Create tablespace statement" [message #354229]

Fri, 17 October 2008 02:12

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

Report message to a moderator

Re: How to generate "Create tablespace statement" [message #354242 is a reply to message #354229]

Fri, 17 October 2008 02:59

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

export - import with ROWS=N also work.

Report message to a moderator

Re: How to generate "Create tablespace statement" [message #354530 is a reply to message #354229]

Mon, 20 October 2008 03:29

ora110
Messages: 42
Registered: September 2007
Location: China

Member

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

Report message to a moderator

Re: How to generate "Create tablespace statement" [message #354534 is a reply to message #354530]

Mon, 20 October 2008 03:46

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 21:28:01 CST 2024