Verification script in RCU Home [message #588552] |
Wed, 26 June 2013 08:37 |
![](http://www.gravatar.com/avatar/1d9b39cbefd9e32cedc8b03e551d4218?s=64&d=mm&r=g) |
Alice85
Messages: 1 Registered: June 2013
|
Junior Member |
![alicia.cazal%40yahoo.es](/forum/theme/orafaq/images/yahoo.png)
|
|
Hello,
After to partition soainfra tables(Administrator's Guide for Oracle SOA Suite and Oracle Business Process Management Suite
11g Release 1 (11.1.1.6.0) E10226-11 Chapter 9), i'm running the verification scripts(A verification script is provided for the DBA to determine when to drop a partition and its equipartitioned dependent table. The verification script is located in MW_HOME/SOA_ORACLE_HOME/rcu/integration/soainfra/sql/verify). When i execute soa_exec_verify.sql and review the logs and SQL files generated in the PART_DIR directory, this files are empty. But i need to drop the partitions by using the script generated with the name SOA_PARTITION_NAME_RESULT_1.sql. I don't know what's wrong, any help?
Sorry about me english,regards
|
|
|