-
Importing data
I have just recently started working with Oracle 8i and have a SQL Server
background. When we wanted to import large amounts of data into a table
in the db we sould use a "bulk copy". Oracle doesn't appear to have anything
like this.
Can anyone give me a tip on taking data in a flat file and importing into
an Oracle db.
Thanks!
-
Re: Importing data
it does, but its a command line (dos) program...
Can't recall the name off-hand...
D.
"Sandy" <smbcat@nol.net> wrote in message news:3ce3afad$1@10.1.10.29...
|
| I have just recently started working with Oracle 8i and have a SQL Server
| background. When we wanted to import large amounts of data into a table
| in the db we sould use a "bulk copy". Oracle doesn't appear to have anything
| like this.
|
| Can anyone give me a tip on taking data in a flat file and importing into
| an Oracle db.
|
| Thanks!
-
Re: Importing data
Sandy,
You are looking for the SQL Loader utility.
http://www.orafaq.com/faqloadr.htm
O'Reilly publishes a book on the utility if the Oracle documentatoin is not
enough for you.
Guy Smith
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Forum Rules
|
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL
|
Bookmarks