Auto partition add/drop function

From: Spears, Brian <BSpears_at_Limitedbrands.com>
Date: Thu, 30 Mar 2006 09:43:47 -0500
Message-ID: <50938E6468CFED40AE0FD7A507D96D340207D4FE@EXCHSERV2.Limited.brands.com>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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:

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;
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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 30 2006 - 08:43:47 CST