You probably have to use DBMS_UTILITY.COMMA_TO_TABLE to read the flat file
into a PL/SQL table and then create a table using Dynamic SQL.
-bhogak
Tim Mavers <webview_at_hotmail.com> wrote in message
news:3afc286e$0$16451$45beb828_at_newscene.com...
> I am trying to figure out how to import a CSV file to a table in Oracle
8i.
>
> I know I can use sqlldr, but this requires control file that describes the
> data to import. The problem I have is the format of this CSV is dynamic.
> Actually it's pretty static, except that the number of columns can change.
>
> Is there a way I can just import a CSV file and have Oracle create the
table
> (I supply the name) for me?
>
> In MS SQL Server, I used DTS which was pretty straightforward. Is there
> something equivalent in Oracle?
>
>
Received on Sat May 12 2001 - 08:59:28 CDT
