Home » RDBMS Server » Server Utilities » oracle_datapump error (merged)
| oracle_datapump error (merged) [message #408263] |
Mon, 15 June 2009 09:12  |
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.
|
|
|
|
|
|
| oracle_datapump error [message #408265 is a reply to message #408263] |
Mon, 15 June 2009 09:16  |
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 #408278 is a reply to message #408265] |
Mon, 15 June 2009 09:49 |
 |
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
Goto Forum:
Current Time: Sat Jan 25 17:05:47 CST 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
