Exporting table data to a flat file
655128Oct 30 2008 — edited Oct 31 2008Hi, I am trying to export data from a table to a text file using this:
CREATE TABLE bufurl
(
url, sno
)
ORGANIZATION EXTERNAL
(
TYPE oracle_datadump
DEFAULT DIRECTORY dataload
LOCATION ('external.txt')
)
AS
SELECT url, sno from table1 where sno > 10
/
but i get this error:
ERROR at line 1:
ORA-29829: implementation type does not exist
any clues what might be going on here?