Temat: Zarządzanie przestrzenią AUD$
Adam Boliński:
Ad 1. Zrobiłem, dlaczego niesupportowane ?? masz jakiś papier oficjalny na to ?? Metoda na metalink jest ok. ja zrobiłem trochę inaczej.
/me znalazło cos takiego:
"E.3.1 Oracle Label Security and the SYS.AUD$ Table
Installing Oracle Label Security automatically moves the AUD$ table out of SYS and into SYSTEM, and into a different tablespace.
Having the AUD$ table in the SYSTEM schema is supported when Oracle Label Security is being used.
When Oracle Label Security is not installed, moving the SYS.AUD$ table out of the SYSTEM tablespace is not supported because the Oracle code makes implicit assumptions about the data dictionary tables, such as SYS.AUD$, in support of upgrades and backup/recovery scenarios. Moving SYS.AUD$ is not supported unless done by Oracle when Oracle Label Security is installed.
E.4 Removing Oracle Label Security
Perform the following steps to remove Oracle Label Security. Do not perform a DROP USER CASCADE on the LBACSYS account to remove Oracle Label Security.
1.
Connect AS SYSDBA.
2.
Run the $ORACLE_HOME/rdbms/admin/catnools.sql script to delete the LBACSYS account.
3.
Use the Oracle Universal Installer to remove Oracle Label Security."
http://download.oracle.com/docs/cd/B28359_01/network.1...