SQL developer: Export schema script with data/index tablespace name?

Question

Currently using SQL Developer with no complaint, now there is a question about how to export schema script with data/index tablespace name on it.

There is an option when right click table => Export => under "Export DLL" there is a check box for "Schema" but not for tablespace.

So how can we achieve massive script exporting with tablespace name all along?

Or, is there any other tool/command to handle the job?

Thank you.

HiltoN · Accepted Answer · 2012-11-01 21:02:47Z

2

You should use Storage option when exporting. To get DDL for a single object you can also use DBMS_METADATA.GET_DDL function but if you need to export whole schema with complex dependencies it is better to use specialized tools like SQL Developer / Toad / PL\SQL Developer, etc.

answered Nov 1, 2012 at 21:02

HiltoN

3281 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL developer: Export schema script with data/index tablespace name?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related