Comments
- Phil Dunn (@Phil_Oracle) on Oracle’s New T5 TPC-C: Where’s the SPARC?, Part II
- ODBC on Installing the Netezza ODBC Driver.
- ashish on View deleted data in Netezza with view_deleted_records.
- Gary on Installing the Netezza ODBC Driver.
- venkat on Installing the Netezza ODBC Driver.
- Gary on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- arnab on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- Hank Classe on ANS1017E (RC-50) Session rejected: TCP/IP connection failure
- Sean Robinson on Registering with Multiple listeners.
- Gary on Sending nzevent emails for system state changes.
Meta
Category Archives: Import/Export
Unloading from oracle to load into Netezza.
Found a very useful utility to unload information from oracle in flatfile format. This makes it simple to load into Netezza. I’ll complete this when I can.
Impdp reports invalid privileges.
A clients import returned the following information using impdp. GRANT FLASHBACK ARCHIVE ADMINISTER TO “MYUSER” ORA-39083: Object type SYSTEM_GRANT failed to create with error: ORA-00990: missing or invalid privilege Failing sql is: GRANT ALTER DATABASE LINK TO “MYUSER” ORA-39083: Object … Continue reading
ORA-39001: invalid argument value with dbms_datapump
Posted in datapump
Comments Off
Export fails over mounted drive.
Kept getting an error running an export. ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation ORA-06512: at “SYS.UTL_FILE”, line 536 ORA-29283: invalid file operation
Posted in datapump
Tagged at SYS.UTL_FILE, expdp, invalid file operation, invalid operation, line 536, ORA-06512, ORA-29283, ORA-39002, ORA-39070, Unable to open the log file
Comments Off
ORA-39125 on impdp with table statistics.
Had a problem the other day with an import which failed with: “ORA-39125: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS while calling DBMS_METADATA.CONVERT [TABLE_STATISTICS]“. The work around was to import with no statistics.
Posted in datapump, Oracle
Tagged calling, DBMS_METADATA.CONVERT, error, fatal, in, KUPW$WORKER.PUT_DDLS, ORA-39125:, unexpected, while, Worker, [TABLE_STATISTICS]
Comments Off
Expdp on Windows.
On windows, it is harder to define the parameters for an export, here’s a working example which performs the datapump export on a database.
Posted in datapump, Import/Export, Oracle
Comments Off
dbms_datapump 10g
DBMS_DATAPUMP The DBMS_DATAPUMP package is used to move all, or part of, a database between databases, including both data and metadata, or for backups.
Posted in datapump, Import/Export, Oracle
Tagged automated, DBMS_DATAPUMP, expdp, EXPORT~JOB, IMPDP
Comments Off
Importing specific object types, oracle 10g
Oracle 10g has the option to import only the object types you require from an export, using the INCLUDE parameter in the argument.
Posted in datapump, Import/Export, Oracle
Comments Off
