Home » RDBMS Server » Server Utilities » how to import external data from text file (oracle 8i windows xp)
how to import external data from text file [message #336378] Sat, 26 July 2008 01:57 Go to next message
Spiritual
Messages: 18
Registered: July 2008
Location: Pakistan
Junior Member

Hi All!!


I want to import external data into Oracle 8i. what is procedure to import data from text file

Regards
Re: how to import external data from text file [message #336381 is a reply to message #336378] Sat, 26 July 2008 02:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL*Loader.

Regards
Michel
Re: how to import external data from text file [message #336903 is a reply to message #336378] Tue, 29 July 2008 05:33 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

You can have a look at,
http://arjudba.blogspot.com/2008/07/how-to-load-or-copy-data-from-sql.html
Re: how to import external data from text file [message #336915 is a reply to message #336903] Tue, 29 July 2008 06:07 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm not complaining, I am really NOT complaining ./fa/1597/0/, but - instead of posting link to a (relatively) funny example - at least, from my point of view ./fa/917/0/ - do you really, but REALLY
suggested BLOG page

Step3: Go to oracle database and create the emp table.
I created as below.
CREATE TABLE "ARJU"."EMP"
( "EMP_NO" NUMBER,
"EMP_NAME" VARCHAR2(10),
"DEPT_NO" NUMBER
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USER_TBS";


create tables like that? If you do, well, you're one of a kind. Perhaps there are people who actually do it that way (enclosing schema, object and column names into double quotes, not to mention storage clause for a simple ETL example, including possibly non-existent information as tablespace name as well as schema name). Newbies' eyes must be wide open ./fa/450/0/ when seeing something that exotic .

Besides, why two "LOAD DATA" lines (./fa/3518/0/)? Why the difference between CHAR and CHAR(10) in the control file? What does "OPTIONALLY ENCLOSED BY '"'" mean?

So, ... instead of posting such an example, people might better use official Oracle documentation regarding SQL*Loader ./fa/3314/0/. Or, you might produce something useful, error-free on your BLOG and let people use it.

LF over and out ./fa/1599/0/
Re: how to import external data from text file [message #336920 is a reply to message #336378] Tue, 29 July 2008 06:30 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Thank you Littlefoot much for guiding me in the correct way. I corrected my writings to make it more easy and tried to make it error free.

In many scenarios, people just want the simplest way to do their task without knowing much about the document. In such case if you give the link of oracle document they simply ignore it. ( I am not saying it will be good for them). In these cases a simple example will help them a lot.

Thanks again for the correction in my blog.
Re: how to import external data from text file [message #336948 is a reply to message #336920] Tue, 29 July 2008 07:38 Go to previous message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Arju
a simple example will help them a lot
I agree. But
Arju
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USER_TBS"
is (oops! was) far from being simple.

P.S. Oh, yes; I visited your BLOG again. They will still be unable to recreate this table as
a) their schema probably won't be "arju"
b) they probably won't have the "user_tbs" tablespace

[Updated on: Tue, 29 July 2008 07:42]

Report message to a moderator

Previous Topic: Export from higher version and import to lower
Next Topic: Max Primary Key Value for Oracle 10g
Goto Forum:
  


Current Time: Wed Dec 07 03:04:30 CST 2016

Total time taken to generate the page: 0.05291 seconds