|
|
|
|
|
|
Re: How to export all of my procedure and packeges from my schema? [message #636851 is a reply to message #636849] |
Mon, 04 May 2015 07:11   |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
netanel wrote on Mon, 04 May 2015 13:59Hello All,
i tried the expdp command but i didn't succeed.
Can anyone help?
C:\Users\Administrator>expdp wtc/wtc include=procedure include=package include=function directory=C:\oraclexe\app\oracle\admin\XE\dpdump dumpfile=a.dmp logfile=b.dmp
Export: Release 11.2.0.2.0 - Production on Mon May 4 14:58:24 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
UDE-00014: invalid value for parameter, 'directory'.
You have to read the documentation about your wrong "directory" parameter value.
You MUST give an ORACLE directory not an OS one.
And I confirm, the command I gave works:
expdp michel/michel schemas=michel include=procedure include=package include=function
Export: Release 11.2.0.3.0 - Production on Lun. Mai 4 14:09:42 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "MICHEL"."SYS_EXPORT_SCHEMA_01": michel/******** schemas=michel include=procedure include=package include=function
Estimate in progress using BLOCKS method...
Total estimation using BLOCKS method: 0 KB
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Master table "MICHEL"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for MICHEL.SYS_EXPORT_SCHEMA_01 is:
D:\USERS\CADOT\ORACLE\112\RDBMS\LOG\EXPDAT.DMP
Job "MICHEL"."SYS_EXPORT_SCHEMA_01" successfully completed at 14:09:54
And when you have an error you MUST post as I did not just tell what you think you did.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|