Oracle 10g data pump error

From: Fowler, Kenneth R <Kenneth.R.Fowler_at_pfizer.com>
Date: Thu, 9 Feb 2006 20:20:13 -0500
Message-ID: <2AFB753ED0140B43A933D24EAC51D7FA03C6A92F@groamrexm01.amer.pfizer.com>

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

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_VIEW

ORA-31685: Object type failed due to insufficient privileges. Failing sql is:
Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" completed with 1 error(s) at 14:27:34

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

Enterprise Informatics - Common Engineering Groton/New London Manager, Database Administration Services Email (Inbox): Kenneth dot R dot Fowler at pfizer dot com Office: T274/T227
Eastern Point Road,
Groton, CT 06340
M/S 5274-2006

LEGAL NOTICE
Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 09 2006 - 19:20:13 CST