Oracle Tips

Use UNC naming convention (\\<server>\<sharepoint>) on CREATE DIRECTORY command.

SQL> create or replace directory z as '\\172.16.1.36\c$\DB_Backup\backupset';

Directory created.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64
bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

C:\Users\Administrator>expdp schemas=idencraft userid=system/sys directory=z log
file=data_pump_dir:log.log

Export: Release 11.2.0.3.0 - Production on Sun Apr 8 11:58:44 2012

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
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_02":  schemas=idencraft userid=system/*****
*** directory=z logfile=data_pump_dir:log.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 130.0 GB
Processing object type SCHEMA_EXPORT/USER