Purge scripts should be available in the directory ,
$ORACLE_HOME/soa/common/sql/soainfra/sql/oracle/122100/soa_purge12/soa_purge_scripts.sql
Download the folloiwng files
extract them
unzip -d . instantclient-basic-linux.x64-12.2.0.1.0.zip
unzip -d . instantclient-sqlplus-linux.x64-12.2.0.1.0.zip
cd /home/oracle/instantclient_12_2
export PATH=/home/oracle/instantclient_12_2:$PATH
export LD_LIBRARY_PATH=/home/oracle/instantclient_12_2
now test the connectivity , for example
sqlplus DEV_SOAINFRA/Welcome1@host-name:1521/orcl
after this
cd $ORACLE_HOME/soa/common/sql/soainfra/sql/oracle/122100/soa_purge12/soa_purge_scripts.sql
run the script
@soa_purge_scripts.sql
Then try with the following ,
begin
soa.DELETE_INSTANCES_IN_PARALLEL(
MIN_CREATION_DATE=> to_timestamp('2016-01-01','YYYY-MM-DD'),
MAX_CREATION_DATE=> to_timestamp('2016-01-01','YYYY-MM-DD'),
BATCH_SIZE=>1000,
MAX_RUNTIME=>20,
RETENTION_PERIOD=>to_timestamp('2016-01-01','YYYY-MM-DD'),
DOP=>4,
MAX_COUNT=>1000,
PURGE_PARTITIONED_COMPONENT=>false,
sql_trace=>false);
end;
and also
begin
soa.DELETE_INSTANCES(
MIN_CREATION_DATE=> to_timestamp('2016-01-01','YYYY-MM-DD'),
MAX_CREATION_DATE=> to_timestamp('2016-01-01','YYYY-MM-DD'),
BATCH_SIZE=>1000,
MAX_RUNTIME=>20,
RETENTION_PERIOD=>to_timestamp('2016-01-01','YYYY-MM-DD'),
PURGE_PARTITIONED_COMPONENT=>false,
sql_trace=>false);
end;
Check the Note
Steps to compile SOA Purge 12.2.1.1 with an explanation (Doc ID 2171885.1)
Tags: Publish
June 04, 2018 at 04:22PM
Open in Evernote
1 comment:
In this manner my acquaintance Wesley Virgin's story starts with this SHOCKING and controversial VIDEO.
Wesley was in the military-and soon after leaving-he revealed hidden, "SELF MIND CONTROL" tactics that the government and others used to obtain everything they want.
These are the same tactics tons of celebrities (notably those who "come out of nowhere") and elite business people used to become rich and successful.
You probably know how you utilize only 10% of your brain.
That's because the majority of your brainpower is UNCONSCIOUS.
Maybe this expression has even taken place IN YOUR very own mind... as it did in my good friend Wesley Virgin's mind seven years ago, while riding an unregistered, garbage bucket of a car without a driver's license and with $3.20 in his bank account.
"I'm very frustrated with living payroll to payroll! When will I get my big break?"
You've been a part of those those types of questions, am I right?
Your success story is waiting to be written. You just need to take a leap of faith in YOURSELF.
Take Action Now!
Post a Comment