Oracle 10g data pump error
- From: "Fowler, Kenneth R" <Kenneth.R.Fowler@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 Feb 2006 20:20:13 -0500
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
Other related posts:
- » Oracle 10g data pump error
