How to save a table as a .ctl

[Maz]

Hi,
I want to save a table as a .ctl (control file) for loading it later through SQL Loader. How can I do that with PL/SQL Developer? I know how to do it with TOAD but we are switching to PL/SQL Developer so I wanted to know if that functionality exists in PL/SQL.

Please help.

Thanks.

 

[Marco Kalter]

There is currently no explicit support for SQL Loader.

 

[Maz]

Thanks for the Reply Marco.

Just wondering... what is the best way to backup a table and then restore it later if needed through PL/SQL Developer? All i want to do is backup a certain table, perform my test and then if the test is unsuccessful, restore the table else keep the created backup for future.

 

[ScottMattes]

1) don't commit, use the test window and a select to view the changes, then click the rollback button

2) make a copy of the table in your own schema and test on that

3) use dbms_flashback to recover

4) use dbms_wm (maybe the BEST)