Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to import a text file
<printdude1968_at_gmail.com> wrote in message
news:1164317208.945667.252060_at_k70g2000cwa.googlegroups.com...
>I did what you suggested and here is the error message I got
what did you do (use)?
Exp/Imp utility, external tables, SQLLoader???
>
> 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 Fri Nov 24 2006 - 10:54:38 CST