Home » RDBMS Server » Server Utilities » oracle_datapump error (merged)
oracle_datapump error (merged) [message #408263] Mon, 15 June 2009 09:12 Go to next message
gauravpuri2002
Messages: 24
Registered: October 2007
Location: Bangalore
Junior Member
Hi I have created an external table as
CREATE TABLE "STAGE"."PTP_POSTED_EXT_ALL"
( "EMPL_ID" VARCHAR2(100),
"RACF_ID" VARCHAR2(100),
"FULL_DATE" VARCHAR2(100),
"BUSINESS_FUNCTION" VARCHAR2(100),
"CONTACTS" VARCHAR2(100),
"SET_COUNT" VARCHAR2(100),
"KEPT_COUNT" VARCHAR2(100),
"NSF_COUNT" VARCHAR2(100),
"KEPT_AMOUNT" VARCHAR2(100),
"BROKEN_COUNT" VARCHAR2(100),
"RESOLVE_RATE_DTL" VARCHAR2(100),
"PAID_HOURS_SDR" VARCHAR2(100),
"OP_HOURS" VARCHAR2(100),
"CBP_PROCD_NUM" VARCHAR2(100),
"CBP_WVFEE_NUM" VARCHAR2(100),
"CBP_WVFEE_AMT" VARCHAR2(100),
"MISC_FEE_NUM" VARCHAR2(100),
"MISC_FEE_AMT" VARCHAR2(100),
"WRAP_TIME_SEC" VARCHAR2(100),
"HANDLE_TIME_SEC" VARCHAR2(100),
"HANDLE_TIME_CONT_SEC" VARCHAR2(100),
"CAT_TRAN_ELG_NUM" VARCHAR2(100),
"CAT_TRAN_DROP_NUM" VARCHAR2(100),
"CAT_TRAN_SUC_NUM" VARCHAR2(100),
"CONT_OPHR" VARCHAR2(100),
"PTP_PERCENT" VARCHAR2(100),
"KEPT_PERCENT" VARCHAR2(100),
"RESOLVE_RATE" VARCHAR2(100),
"REVPH" VARCHAR2(100),
"CONTACTS_DIALER" VARCHAR2(100),
"NONCONTACTS_DIALER" VARCHAR2(100),
"RUN_DATE" VARCHAR2(100)
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_DATAPUMP
DEFAULT DIRECTORY "FLAT_FILES_DATA"
ACCESS PARAMETERS
( RECORDS DELIMITED BY NEWLINE
BADFILE FLAT_FILES_BAD:'PTPPOSTED_%P.BAD'
LOGFILE FLAT_FILES_LOG:'PTPPOSTED_%P.LOG'
SKIP 1
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
MISSING FIELD VALUES ARE NULL
(
EMPL_ID,
RACF_ID,
FULL_DATE,
BUSINESS_FUNCTION,
CONTACTS,
SET_COUNT,
KEPT_COUNT,
NSF_COUNT,
KEPT_AMOUNT,
BROKEN_COUNT,
RESOLVE_RATE_DTL,
PAID_HOURS_SDR,
OP_HOURS,
CBP_PROCD_NUM,
CBP_WVFEE_NUM,
CBP_WVFEE_AMT,
MISC_FEE_NUM,
MISC_FEE_AMT,
WRAP_TIME_SEC,
HANDLE_TIME_SEC,
HANDLE_TIME_CONT_SEC,
CAT_TRAN_ELG_NUM,
CAT_TRAN_DROP_NUM,
CAT_TRAN_SUC_NUM,
CONT_OPHR,
PTP_PERCENT,
KEPT_PERCENT,
RESOLVE_RATE,
REVPH,
CONTACTS_DIALER,
NONCONTACTS_DIALER,
RUN_DATE
)
)
LOCATION
( "FLAT_FILES_DATA":'ptpposted.txt'
)
)
REJECT LIMIT UNLIMITED;

when i am running
SELECT * FROM STAGE.PTP_POSTED_EXT_ALL;
I am getting error

ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "identifier": expecting one of: "logfile,
nologfile, version" etc..
KUP-01008: the bad identifier was: RECORDS
KUP-01007: at line 1 column 1
ORA-06512: at "SYS.ORACLE_DATAPUMP", line 19

so please help.
Re: oracle_datapump error [message #408264 is a reply to message #408263] Mon, 15 June 2009 09:14 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
oracle_datapump error [message #408265 is a reply to message #408263] Mon, 15 June 2009 09:16 Go to previous messageGo to next message
gauravpuri2002
Messages: 24
Registered: October 2007
Location: Bangalore
Junior Member
Hi I have created an external table as
CREATE TABLE "STAGE"."PTP_POSTED_EXT_ALL"
( "EMPL_ID" VARCHAR2(100),
"RACF_ID" VARCHAR2(100),
"FULL_DATE" VARCHAR2(100),
"BUSINESS_FUNCTION" VARCHAR2(100),
"CONTACTS" VARCHAR2(100),
"SET_COUNT" VARCHAR2(100),
"KEPT_COUNT" VARCHAR2(100),
"NSF_COUNT" VARCHAR2(100),
"KEPT_AMOUNT" VARCHAR2(100),
"BROKEN_COUNT" VARCHAR2(100),
"RESOLVE_RATE_DTL" VARCHAR2(100),
"PAID_HOURS_SDR" VARCHAR2(100),
"OP_HOURS" VARCHAR2(100),
"CBP_PROCD_NUM" VARCHAR2(100),
"CBP_WVFEE_NUM" VARCHAR2(100),
"CBP_WVFEE_AMT" VARCHAR2(100),
"MISC_FEE_NUM" VARCHAR2(100),
"MISC_FEE_AMT" VARCHAR2(100),
"WRAP_TIME_SEC" VARCHAR2(100),
"HANDLE_TIME_SEC" VARCHAR2(100),
"HANDLE_TIME_CONT_SEC" VARCHAR2(100),
"CAT_TRAN_ELG_NUM" VARCHAR2(100),
"CAT_TRAN_DROP_NUM" VARCHAR2(100),
"CAT_TRAN_SUC_NUM" VARCHAR2(100),
"CONT_OPHR" VARCHAR2(100),
"PTP_PERCENT" VARCHAR2(100),
"KEPT_PERCENT" VARCHAR2(100),
"RESOLVE_RATE" VARCHAR2(100),
"REVPH" VARCHAR2(100),
"CONTACTS_DIALER" VARCHAR2(100),
"NONCONTACTS_DIALER" VARCHAR2(100),
"RUN_DATE" VARCHAR2(100)
)
ORGANIZATION EXTERNAL
( TYPE ORACLE_DATAPUMP
DEFAULT DIRECTORY "FLAT_FILES_DATA"
ACCESS PARAMETERS
( RECORDS DELIMITED BY NEWLINE
BADFILE FLAT_FILES_BAD:'PTPPOSTED_%P.BAD'
LOGFILE FLAT_FILES_LOG:'PTPPOSTED_%P.LOG'
SKIP 1
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
MISSING FIELD VALUES ARE NULL
(
EMPL_ID,
RACF_ID,
FULL_DATE,
BUSINESS_FUNCTION,
CONTACTS,
SET_COUNT,
KEPT_COUNT,
NSF_COUNT,
KEPT_AMOUNT,
BROKEN_COUNT,
RESOLVE_RATE_DTL,
PAID_HOURS_SDR,
OP_HOURS,
CBP_PROCD_NUM,
CBP_WVFEE_NUM,
CBP_WVFEE_AMT,
MISC_FEE_NUM,
MISC_FEE_AMT,
WRAP_TIME_SEC,
HANDLE_TIME_SEC,
HANDLE_TIME_CONT_SEC,
CAT_TRAN_ELG_NUM,
CAT_TRAN_DROP_NUM,
CAT_TRAN_SUC_NUM,
CONT_OPHR,
PTP_PERCENT,
KEPT_PERCENT,
RESOLVE_RATE,
REVPH,
CONTACTS_DIALER,
NONCONTACTS_DIALER,
RUN_DATE
)
)
LOCATION
( "FLAT_FILES_DATA":'ptpposted.txt'
)
)
REJECT LIMIT UNLIMITED;

when i am running
SELECT * FROM STAGE.PTP_POSTED_EXT_ALL;
I am getting error

ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "identifier": expecting one of: "logfile,
nologfile, version" etc..
KUP-01008: the bad identifier was: RECORDS
KUP-01007: at line 1 column 1
ORA-06512: at "SYS.ORACLE_DATAPUMP", line 19

so please help.
Re: oracle_datapump error [message #408268 is a reply to message #408265] Mon, 15 June 2009 09:20 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
do NOT cross/multi-post!
Re: oracle_datapump error [message #408278 is a reply to message #408265] Mon, 15 June 2009 09:49 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Quote:
KUP-01005: syntax error: found "identifier": expecting one of: "logfile,
nologfile, version" etc..
KUP-01008: the bad identifier was: RECORDS
KUP-01007: at line 1 column 1
ORA-06512: at "SYS.ORACLE_DATAPUMP", line 19


Regards
Michel
Previous Topic: export error
Next Topic: Error while importing
Goto Forum:
  


Current Time: Mon Dec 05 21:35:45 CST 2016

Total time taken to generate the page: 0.09048 seconds