Re: How to import a text file

I did what you suggested and here is the error message I got

Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; No message file for product=RDBMS, facility=UL

Tomo wrote:
> <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:26:49 CST