Re: External Database [3 Attachments]
Marvin Rios <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
Attach File view steep for creation external table. ________________________________ From: Marvin Rios <[email protected]> To: "[email protected]" <[email protected]> Sent: Friday, February 17, 2012 5:30 PM Subject: Re: [toad] External Database script of creation CREATETABLEMOBILE.RECIBO_DATA(LOTE VARCHAR2(50BYTE) ) ORGANIZATIONEXTERNAL(TYPEORACLE_LOADER DEFAULTDIRECTORYCONSIGNACIONACCESSPARAMETERS(RECORDS DELIMITED BYNEWLINE FIELDS (LOTE POSITION(1:25)CHAR(50),))LOCATION(CONSIGNACION:'Archivo.txt')) REJECTLIMITUNLIMITED From: Marvin Rios <[email protected]> To: Toad Oracle <[email protected]> Sent: Friday, February 17, 2012 5:26 PM Subject: [toad] External Database Hello All when Select * from DATA_RECIBO; send to message 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 ")": expecting one of: "double-quoted-string, identifier, single-quoted-string" KUP-01007: at line 5 column 5 ORA-06512: at "SYS.ORACLE_LOADER", line 19