Re: How to import a text file

printdude1968_at_gmail.com wrote:
> I am migrating from Oracle 10gXE to Oracle 10g on RHEL4.
> I have exported my tables from the XE installation and created text
> files out of the data.
> I created tables in 10g and now need to import the data back into the
> empty tables.
> I have a connection to the database (orcl SID) set up in sqldeveloper
> and can connect to it without any problems.
> However, when I try to import the data, it doesn't work.
> Isn't there an import data or other statement that I can use to do the
> job?
> The data is of the format
> ...
>
> I've search the web and all the docs I can find and can not locate the
> command I need. Any help would
> be appreciated..

Why not directly import the data via a Database Link ? If you want to go via files: I think in 10g you are supposed to use External Tables to accomplish such an export/import procedure.

br,
Martin Received on Thu Nov 23 2006 - 06:31:15 CST