Pulling Schema without Data

[jestrada101]

What is the quickest way to pull Schema DDL from an oracle schema (9i)?

I have a schema with tons of tables, indexes, etc... and I want to pull that to another database without pulling the data with it... it will be on a diff. tablespaces, etc...

Thanks for any ideas!

Thanks
JE

 

[SantaMufasa]

JE,

Just do your "exp" with the parameter "rows=n"...the structure will export, but not the data.

Let us know how that works for you.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[jestrada101]

Thanks. Woudl this require me to create the same tablespaces on teh new system? I'm move these tables to a test system.. and dont care to create the tons of tablespaces that are used on the existing.

 

[SantaMufasa]

JE,

If the old tablespace name does not appear on the target database, then the target db's "imp" will place the tables in the DEFAULT tablespace of the owning Oracle user/schema.

Let us know if you see differing behaviour.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[Turkbear]

Hi,
If the tablespaces do not exist on the system you are importing into, the tables will go into the default tablespace for the User running the Import..

( Using ignore='Y' may speed things up)






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[jestrada101]

thanks.. i'll give it a shot.. i'll let you know how it goes!

JE