Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

export and import only table structure

827207Dec 14 2011 — edited Dec 14 2011
Hi ,

I have two schema scott and scott2. scott schema is having table index and procedure and scott2 schema is fully empty.

Now i want the table structure, indexes and procedure from scott schema to scott2 schema. No DATA needed.

What is the query to export table structure, indexes and procedure from scott schema and import in scott2 schema.

Once this done, i want scott schema should have full access to scott2 schema.


Oracle Database 10g Release 10.2.0.1.0 - 64bit Production

Please help...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 11 2012
Added on Dec 14 2011
#database-key-features, #export-import-sql-loader-external-tables
9 comments
22,695 views