How to export user/schema WMSYS
sanju2Nov 21 2006 — edited Nov 21 2006Trying to export WMSYS using datapump. Output is shown below. Need help....
Schema is present and has procedure/functions/types [encripted]/tables etc.
------------------------------------------------------------------------------------------------------------------------------
C:\>expdp system@orcl directory=data_pump_dir dumpfile=wmsys.dmp logfile=wmsys.log schemas=wmsys
Export: Release 10.2.0.1.0 - Production on Tuesday, 21 November, 2006 16:53:32
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Password:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/********@orcl directory=data_pump_dir dumpfile=wmsys.dmp logfile=wmsys
.log schemas=wmsys
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
ORA-39165: Schema WMSYS was not found.
ORA-31655: no data or metadata objects selected for job
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" completed with 2 error(s) at 16:54:15
------------------------------------------------------------------------------------------------------------------------------
Also tried with exp. Below is output-
C:\>exp userid=system@orcl owner=wmsys file=c:\oratmp\wmsys.dmp log=C:\oratmp\wmsys.log
Export: Release 10.2.0.1.0 - Production on Tue Nov 21 17:42:41 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Password:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
About to export specified users ...
EXP-00010: WMSYS is not a valid username
Export terminated successfully with warnings.
Thanks and regards.