How to import a text file

From: <printdude1968_at_gmail.com>
Date: 23 Nov 2006 03:28:48 -0800
Message-ID: <1164281328.015923.197950@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.
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 - 05:28:48 CST