Fulltext results:

Oracle: Recovery Manager

5 Hits, Last modified: 13 years ago

</code> ===== Delete Archive Logs ===== Delete all archive logs but keep the last 45 days: <code sql> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -45'; </code> To remo... ackup run: <code sql> DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE -45'; </code> A sample script could be (deleting all logs except the last three days): <code bash> #

Oracle: Resize Instance

4 Hits, Last modified: 13 years ago

nge the [[spfile_and_pfiles|SPFile]]: <code sql> ALTER SYSTEM SET pga_aggregate_target = 2G SCOPE=SPFILE; ALTER SYSTEM SET sga_target = 6G SCOPE=SPFILE; </code> Then, (optionally) export the SPFile to a PFile: <code sql> CREATE PFILE FROM SPFILE; </code> Finally, reboot the instance to activate the change: <

Oracle: SPFile and PFiles

4 Hits, Last modified: 13 years ago

====== Oracle reads its parameters from a file called "SPFile". You can't change it directly as it's a binary file. Additionally, Oracle can read the parameters from "PFiles", ... le/config/pfiles/initweb.ora' </code> ===== Initialization Parameters ===== ==== Flash Recovery Area... it param in memory and in the SPFile. <code sql> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=8G SCOPE

Oracle: List Accounts with Objects

3 Hits, Last modified: 13 years ago

racle: List Accounts with Objects ====== To list all accounts (users) the objects (like tables), you ... ECTS ORDER BY OWNER; </code> If you want to list all accounts, you can query them with: <code sql> SELECT USERNAME FROM ALL_USERS ORDER BY USERNAME; </code> Or, if you onl

Oracle: EXP

1 Hits, Last modified: 13 years ago

====== Oracle: EXP ====== ===== Export all Objects from an Account ===== Enter the account name inst

Oracle Errors

1 Hits, Last modified: 13 years ago

= ===== ORA-00257: archiver error. Connect internal only, until freed. ===== * **Reason**: The fla