|
|
|
Re: how to import external data from text file [message #336915 is a reply to message #336903] |
Tue, 29 July 2008 06:07 |
|
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I'm not complaining, I am really NOT complaining , but - instead of posting link to a (relatively) funny example - at least, from my point of view - 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 when seeing something that exotic .
Besides, why two "LOAD DATA" lines ()? 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 . Or, you might produce something useful, error-free on your BLOG and let people use it.
LF over and out
|
|
|
|
Re: how to import external data from text file [message #336948 is a reply to message #336920] |
Tue, 29 July 2008 07:38 |
|
Littlefoot
Messages: 21818 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
|
|
|