OraFAQ Forum: Server Utilities » Full Meta Schema Dump

Home » RDBMS Server » Server Utilities » Full Meta Schema Dump

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

Full Meta Schema Dump [message #70781]

Tue, 23 July 2002 00:23

Coomans
Messages: 1
Registered: July 2002

Junior Member

Hi All,

The Goal is to create a clone of a database but WITHOUT the data. What is the best way.

I though about dumping/Reloading the full Meta Schema.(Table, Triggers, Constraint, Synonymes, Indexes, Packages, Procedures ..........)

How this can be achieve? Is there any Oracle Standard script to do this?

Report message to a moderator

Re: Full Meta Schema Dump [message #70783 is a reply to message #70781]

Tue, 23 July 2002 01:56

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

you can just use a full database export.
while importing say rows=N ( do not import data).

Report message to a moderator

Re: Full Meta Schema Dump [message #70785 is a reply to message #70783]

Tue, 23 July 2002 05:31

Grant
Messages: 578
Registered: January 2002

Senior Member

exp system/manager full=Y rows=n ...
imp system manager ...

Report message to a moderator

Re: Full Meta Schema Dump [message #70806 is a reply to message #70781]

Thu, 25 July 2002 19:49

sunil bhola
Messages: 58
Registered: July 2002

Member

For this you can do a single thing i.e
while importing use ROWS=N( it will not import the data)

Report message to a moderator

Previous Topic:	Oracle Installation files
Next Topic:	connection pool using proC/C++

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 15:51:01 CST 2025