Auto partition add/drop function
- From: "Spears, Brian" <BSpears@xxxxxxxxxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 30 Mar 2006 09:43:47 -0500
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:
- » Auto partition add/drop function
