1 / 8

Oracle SQL*Loader

Designed by : Kartik Mali. Email : kartik_dodia85@yahoo.co.in. Oracle SQL*Loader. Dear Friends, I m Kartik Mali from gujarat. I prepared this presentation for who want to use oracle loader utility. I m giving here step by step knowledge of oracle

zhen
Download Presentation

Oracle SQL*Loader

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Designed by : Kartik Mali Email : kartik_dodia85@yahoo.co.in Oracle SQL*Loader Dear Friends, I m Kartik Mali from gujarat. I prepared this presentation for who want to use oracle loader utility. I m giving here step by step knowledge of oracle 10g loader. I m giving knowledge about how to export MS Access database’s table into oracle 10g with oracle loader.

  2. Designed by : Kartik Mali Email : kartik_dodia85@yahoo.co.in Oracle SQL*Loader Step : 1 • Right click on your table, then select export menu. • Convert your table into MS Excel latest version.

  3. Designed by : Kartik Mali Email : kartik_dodia85@yahoo.co.in Oracle SQL*Loader Step : 2 1. Open your MS Excel File, then go to File menu, then select Save As. 2. Save your file in CSV (Comma Delimited) Format.

  4. Designed by : Kartik Mali Email : kartik_dodia85@yahoo.co.in Oracle SQL*Loader Step : 3 1. you will see your file as this format. 2. Now Copy your file on Oracle Path. Ex. c:\oracle\test_table.csv

  5. Designed by : Kartik Mali Email : kartik_dodia85@yahoo.co.in Oracle SQL*Loader Step : 4 • Now we have to create a Control file (There is • difference between DATABASE CONTROLFILE and SQL • LOADER CONTROL FILE) • 2. Now create a table in ORACLE with same coloum name • and data type (there is defference between MS Access • data type and ORACLE data type Ex. MS Access data • types = text, ORACLE data type = char or varchar2

  6. LOAD DATA INFILE ‘full path’ (where CSV file located) BADFILE ‘full path’ (Ex. ‘C:\oracle\test.bad’) DESCARDFILE ‘full path’ (Ex. ‘C:\oracle\test.dsc’) insert into table <Table Name> fields terminated by “,” optionally enclosed by ‘ “ ‘ trailing nullcols. Designed by : Kartik Mali Email : kartik_dodia85@yahoo.co.in Oracle SQL*Loader Step : 5 1. Open Note Pad or any text format file, and type following lines. 2. Save this file.

  7. Designed by : Kartik Mali Email : kartik_dodia85@yahoo.co.in Oracle SQL*Loader Step : 6 1.Open Command Prompt. • Type here : • sqlldr username/password 2. Type here sqlldr username/password C:\> sqlldr scott/tiger control = 3. Drag your SQL Loader control file and Drop here. 4. Then you will see how many records are inserted.

  8. Oracle SQL*Loader Please send your comment on : kartik_dodia85@yahoo.co.in Thanks

More Related