Auto partition add/drop function

Hi,
 We have a nice bunch of pl/sql code and perl to add drop all partitions
Range partitions on a weekly or monthly basis . I am looking for a data
driven model ... anybody know of examples out there? 
Brian 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Li Li
Sent: Friday, March 17, 2006 5:41 PM
To: oracle-l
Subject: data pump


Hi, All
 
I am trying to use data pump to export the whole database (db version
10.1.0.4). Here is what I have done:
 
1. login sys as sysdba and created the directory as follows:
create directory dumpdir as 'D:\dbback\orcl\export';
grant read, write on directory dumpdir to system;
 
2. run expdp as follows:
expdp system/password full=y directory=dumpdir dumpfile=full_exp.dmp
job_name=full_exp logfile=full_exp.log
 
then expdp just hang up, log is as follows:

Export: Release 10.1.0.4.0 - Production on Friday, 17 March, 2006 16:14

Copyright (c) 2003, Oracle.  All rights reserved.
;;; 
Connected to: Oracle Database 10g Release 10.1.0.4.0 - Production
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYSTEM"."FULL_EXP":  system/******** full=y directory=dumpdir
dumpfile=full_exp.dmp job_name=full_exp logfile=full_exp.log 
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64.18 MB
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE 
Processing object type DATABASE_EXPORT/DE_SYS_USER/USER
Processing object type DATABASE_EXPORT/SCHEMA/USER
Processing object type DATABASE_EXPORT/ROLE
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT 
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE
Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA 
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
Processing object type DATABASE_EXPORT/SCHEMA/SEQUENCE/SEQUENCE
Processing object type
DATABASE_EXPORT/SCHEMA/SEQUENCE/GRANT/DE_S_SEQ_OWNER_OBJGRANT/OBJECT_GRANT 
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/CONTEXT
Processing object type DATABASE_EXPORT/SCHEMA/DE_PUBLIC_SYNONYM/SYNONYM 
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/TYPE/TYPE_SPEC
Processing object type
DATABASE_EXPORT/DE_SYSTEM_PROCOBJACT/DE_PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM 
Processing object type
DATABASE_EXPORT/DE_SYSTEM_PROCOBJACT/DE_POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/SCHEMA/CLUSTER/CLUSTER 
Processing object type DATABASE_EXPORT/SCHEMA/CLUSTER/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE


Any thoughts? TIA

Other related posts: