External tables in Oracle

[dilippanda]

Hi,

Please let me know about the concept behind External tables.
How to select data from External Tables.

It's urgent for me.
Please help me.

Thanks,
Dilip

[debasisdas]

please find the details here

[dilippanda]

Hi,

wrk_cbx_respons e_ext is the external table in my scenario.

Whenever i am trying to select data from this table it is throwing me the following error.

ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPE N callout
ORA-29400: data cartridge error
KUP-04040: file CBX_Response_Fe edback^20070405 _1.dat in GCA_CBXRF not found
ORA-06512: at "SYS.ORACLE_LOA DER", line 14
ORA-06512: at line 1

Please help me how to select data from this table.

Thanks,
Dilip

please find the details here

[debasisdas]

please follow the steps provides in the link carefully

take special care while creating directory and grant preveliges

If u dont have the previleges log in through the SYS/SYSTEM account or ask your DBA to do the same for you

[dilippanda]

Hi,

The link you have provided tells
2.EXTERNAL TABLES CAN BE QUERIED IN THE SAME WAY AS STANDARD TABLES IN JOINS,VIEWS.... .AND CAN USE ALL TYPES OF FUNCTION ON THE EXTERNAL TABLE.

But i am not able to select data from my external table.

I also don't have grant privileges grant priveleges on the directory.

Please suggest me.

Thanks,
Dilip

please follow the steps provides in the link carefully

take special care while creating directory and grant preveliges

If u dont have the previleges log in through the SYS/SYSTEM account or ask your DBA to do the same for you

[Saii]

When you specify the dir_obj name in external table defination, you should have access to that location so that you can read data from file.
Also check whether you have mapped the columns correctly.

[debasisdas]

simply copy and paste the code from the link and try to execute

You change the code later on as per your requirment.