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_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. -- //www.freelists.org/webpage/oracle-l