Home » SQL & PL/SQL » SQL & PL/SQL » could you help me import and export a file
could you help me import and export a file [message #19791] Wed, 10 April 2002 04:24 Go to next message
Younes
Messages: 3
Registered: April 2002
Junior Member
Hi...
What i need is to import a text file so that the data from it will fill the fields of a table. And then export the result from it to another application. The problem is that the application we are exporting to is 16 bit base whereas Oracle is 32 bit.
Re: could you help me import and export a file [message #19796 is a reply to message #19791] Wed, 10 April 2002 06:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I beleive u are loooking into LOADING the data from one app to another app, via flat files.
U cannot use import/export to do this(text/flatfiles).
u need to make use of sql*loader.
1. create a flat file of the existing tables.
2. load the flat file into the target app.
3. since the data is in text files, 16/32 bit doesnt matter.
Re: could you help me import and export a file [message #19798 is a reply to message #19791] Wed, 10 April 2002 09:07 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
please go to
http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76955/ch04.htm#534

this document clearly exaplains the pros and cons in using sqlloader with different options.
to acces, all u need is an OTN membership which is free.
u may require certain priviliges to this operation in the database. consult your DBA for the privs.
regards
Previous Topic: Can do it in SQL PLUS but not in PL/SQL
Next Topic: Re: Calling stored procedures in visual Basic
Goto Forum:
  


Current Time: Fri Mar 29 09:15:40 CDT 2024