I wanted to set the archive destination parameter. I don't know what USE_DB_RECOVERY_FILE_DEST means. Is this another parameter? Does this mean that it has already been set? I tried issuing the alter system command to set the destination parameter and got the following error:
SQL> alter system set log_archive_dest='/u04/archive_log';
alter system set log_archive_dest='/u04/archive_log'
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or
I don't know what this means. Could someone please help me to resolve this issue?
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…