Oracle Tidbits: Difference between revisions
Jump to navigation
Jump to search
(initial page with archive log tidbit) |
(Retrieving DDL from Oracle 9) |
||
| Line 8: | Line 8: | ||
<li>alter system set log_archive_dest_1="LOCATION=F:\ORACLE\EDWD" SCOPE=MEMORY;</li> | <li>alter system set log_archive_dest_1="LOCATION=F:\ORACLE\EDWD" SCOPE=MEMORY;</li> | ||
</ul> | </ul> | ||
==Retrieving DDL from Oracle 9i== | |||
Use this: | |||
<blockquote>SELECT DBMS_METADATA.GET_DDL(object_type, object_name, owner)</blockquote> | |||
as in: | |||
<blockquote>SELECT DBMS_METADATA.GET_DDL('TABLE', MY_TABLE, CHIP);</blockquote> | |||
Revision as of 16:10, 10 March 2008
Useful things I always forget about Oracle
If Archive Logs Fill Up
After you've made some space, or to direct archiving to an emptier place, remind Oracle where to right the archive files. When it locks up, it resets something in memory that needs to be reset.
- SQLPLUS /NOLOG
- Connect internal
- alter system set log_archive_dest_1="LOCATION=F:\ORACLE\EDWD" SCOPE=MEMORY;
Retrieving DDL from Oracle 9i
Use this:
SELECT DBMS_METADATA.GET_DDL(object_type, object_name, owner)
as in:
SELECT DBMS_METADATA.GET_DDL('TABLE', MY_TABLE, CHIP);