Re: How to import a text file

<printdude1968_at_gmail.com> wrote in message news:1164281328.015923.197950_at_h54g2000cwb.googlegroups.com...
>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.

if you exported tables using export utility then you should use imort utilty to import data
On Windows OS run command prompt and explore commands "exp help = y" or "imp help = y"

otherwise you might use external tables or use clasical AScii import with ctr file (SQLLoader). First you have to create contol file, eg.

LOAD DATA
INFILE file.ext
INTO TABLE table_name
(column_name POSITION (01:02) INTEGER EXTERNAL, ....etc etc
then in command prompt type sqlldr user/pass_at_database control = ctrl.ctl

> 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
>
> ID integer
> NODE varchar2 30
> USER varchar2 30
> PASS varchar2 30
> URL varchar2 30
> NOTE varchar2 30
>
> And if I do a describe passwords I get this
>
> describe passwords;
> Name Null Type
>
>
>
> ------------------------------ --------
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> NODEID VARCHAR2(255)
>
>
>
> USERID VARCHAR2(255)
>
>
>
> PASSWORD VARCHAR2(30)
>
>
>
> URL VARCHAR2(255)
>
>
>
> NOTE VARCHAR2(255)
>
>
>
> ID NUMBER
>
>
> 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..
>
Received on Thu Nov 23 2006 - 15:31:08 CST