Toad World® Forums

Suggestion for new functionality in external tables


#1

Hi!

Something new to add, i know it’a a lot of work to do but… wahat can you do to be the best!

The new thing is the oracle_datapump loader type. So do the following:
–first create directory
create or replace directory test_a_dir as ‘d:’;
–datapump organized table
CREATE TABLE test_a
ORGANIZATION EXTERNAL (TYPE oracle_datapump
DEFAULT DIRECTORY SIZ_LUT_DATA_122005
LOCATION (
test_a_dir:‘Export.dat’
)
) as select * from all_tables;

Sqlnav is working with this table as with normal external table with oracle_loader type. Simple try edit this table or ddl.

Regards Piter


#2

Hi Piter,

Thanks again for your request and sending this in.

We will raise a request on your behalf. We will consult with Daniel to evaluate this for in a future release post 5.5.

Thanks and regards,
Bruce.

Note: Will remind Andrew that he would need to look for Polish beer for everyone .


#3

Guys,
I’ve got message.
Andrew .