Home » SQL & PL/SQL » SQL & PL/SQL » how to import data from other database to oracle database
how to import data from other database to oracle database [message #8745] Tue, 23 September 2003 06:10 Go to next message
NS Jagan
Messages: 6
Registered: September 2003
Junior Member
eg. import data from excel worksheet to oracle database.it is possible

Report message to a moderator

Re: how to import data from other database to oracle database [message #8748 is a reply to message #8745] Tue, 23 September 2003 07:50 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Jagan,
You can generate a comma(or a suitable field separator) delimited flat ascii file from Excel and load the flat file into Oracle tables using SQLLoader.

For demo on how to load , have a look at $ORACLE_HOME/rdbms/demo/ul* files.

Basically you create tables in Oracle whose struture is determined by your data model/data.
Generate the flat data file from Excel and transport it to your Oracle Server(for faster loading).
Create Sql*Loader control file that interprets your datafile and matches the fields with those database columns and instructs Oracle how to load.
Finally,Use SqlLoader to load the data into one or more tables.

Thiru

Report message to a moderator

Previous Topic: using of rowid
Next Topic: Modify System Tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 08:28:52 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.