Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Oracle 10g data pump error
Hi,
I tried using data pump for the first time today and am getting the following error (Solaris 5.9 and Oracle 10.2.0.1)...
gsun863-enid1 $ impdp system DUMPFILE=pcv.dmp DIRECTORY=pcv_export
SCHEMAS=pcv_owner \
> EXCLUDE=INDEX,REF_CONSTRAINT REMAP_TABLESPACE=PCV_DATA:PCV_OWNER_D1
REMAP_TABLESPACE=PCV_INDX:PCV_OWNER_D1 LOGFILE=import1.log \
> CONTENT=METADATA_ONLY
Import: Release 10.2.0.1.0 - 64bit Production on Thursday, 09 February,
2006 14:26:23
Copyright (c) 2003, 2005, Oracle. All rights reserved. Password:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
- 64bit Production
With the Partitioning, OLAP and Data Mining options
Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully
loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01": system/********
DUMPFILE=pcv.dmp DIRECTORY=pcv_export SCHEMAS=pcv_owner EXCLUDE=INDEX,RE
Processing object type SCHEMA_EXPORT/USER Processing object type SCHEMA_EXPORT/SYSTEM_GRANT Processing object type SCHEMA_EXPORT/ROLE_GRANT Processing object type SCHEMA_EXPORT/DEFAULT_ROLE Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE Processing object type SCHEMA_EXPORT/TABLE/TABLE Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/COMMENT Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION Processing object type SCHEMA_EXPORT/VIEW/VIEW Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEWORA-31685: Object type failed due to insufficient privileges. Failing sql is:
gsun863-enid1 $ oerr ora 31685
31685, 00000, "Object type %s failed due to insufficient privileges.
Failing sql is:\n%s"
// *Document: NO
Anyone seen this? Any ideas?
Thanks,
Ken
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 09 2006 - 19:20:13 CST
![]() |
![]() |