Hi,
I need a help to load data from a flat text file into a table. For this I
applied the following command
SQL> CONNECT SYSTEM/MANAGER;
SQL> CREATE OR REPLACE DIRECTORY PAY_DATA AS 'D:\TEMP';
SQL> GRANT ALL ON DIRECTORY PAY_DATA TO PAYROLL;
SQL> GRANT READ,WRITE ON DIRECTORY PAY_DATA TO PAYROLL;
SQL> CONNECT PAYROLL/PPP;
SQL> CREATE TABLE pull_data (
data VARCHAR2(35)
)
ORGANIZATION EXTERNAL (
TYPE ORACLE_LOADER
DEFAULT DIRECTORY PAY_DATA
ACCESS PARAMETERS (
RECORDS DELIMITED BY NEWLINE
MISSING FIELD VALUES ARE NULL
(
data CHAR(35)
)
)
LOCATION ('d:\temp\02085802.t08')
)
PARALLEL 5
REJECT LIMIT UNLIMITED
SQL> /
Table created.
SQL> DESC PULL_DATA
Name Null? Type
----------------------------------------- -------- -------------------
DATA VARCHAR2(35)
SQL> select *from pull_data;
select *from pull_data
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing input commands
KUP-01005: syntax error: found "missing": expecting one of: "badfile,
characterset, data, delimited, discardfile, exit, fields, fixed, load, logfile,
nodiscardfile, nobadfile, nologfile, processing, string, skip, variable"
KUP-01007: at line 2 column 6
ORA-06512: at "SYS.ORACLE_LOADER", line 14
ORA-06512: at line 1
-----------------------------
WHY I AM GETTING THIS ERROR, COULD ANY ONE TELL ME ... TEXT FILE IS ALREADY
LOCATED IN D:\TEMP.
FURTHER MORE, THIS TEXT FILE '02085802.t08' WILL BE CREATED ON NEXT DAY AND
NAME MIGHT BE 06082702.T08 ,
How can be picked the lates file name ( LOCATION (??????) )
created by the operation system from the client machine C:\time_machine\Data\
I am using Forms Oracle 10g Rel2 and Database 9i R2, Application SErver 10g.
Kindly note that, this routine will be run from client machine not from the
server.
Thanks and regards.
Priya
Connect with friends all over the world. Get Yahoo! India Messenger at
http://in.messenger.yahoo.com/?wm=n/
[Non-text portions of this message have been removed]
------------------------------------
To unsubscribe from this list, please email [EMAIL PROTECTED] & you will be
removed.Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/LINUX_Newbies/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/LINUX_Newbies/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
