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!

Tables dump

Ramesh TMar 30 2015 — edited Mar 31 2015

Hi All,

I want to copy only table structure not data from one schema to another schema in same in database.

any help ..?

and i tried following way ,

create table

select * from testname.te4

select * from item where 1=0;

But i have plenty of tables.how to do the in single way export from one schema to another schema all table not data..

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 28 2015

Added on Mar 30 2015

#database-key-features, #export-import-sql-loader-external-tables

13 comments

2,430 views