How to pipe a schema from one database to another?

[huchen]

Hello,

I need to import all objects in "scott" schema from DB1 to DB2, I need all objects, including table definiations, constraints, stored functions/packages and etc, everything in this schema except data. I do not need any data from any table, not a single row.

Can I do this in sqlplus?
If it can not be done in sqlplus, Please tell me few options if there are some.

Thank you very much in advance.

 

[LKBrwnDBA]

Use exp(ort)/imp(ort) with rows=no (data=no) option(s).

-- Or -- use similar option with datapump (expdb).

-- Or -- use SQL Developer to export schema DDL.




----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[huchen]

thank you. I am all set