Oracle Tidbits: Difference between revisions

From ChipWiki
Jump to navigation Jump to search
(Retrieving DDL from Oracle 9)
(Clean Output SQLPlus Settings)
Line 13: Line 13:
as in:
as in:
<blockquote>SELECT DBMS_METADATA.GET_DDL('TABLE', MY_TABLE, CHIP);</blockquote>
<blockquote>SELECT DBMS_METADATA.GET_DDL('TABLE', MY_TABLE, CHIP);</blockquote>
==Setting Up a Clean Output for long Spools from SQL*Plus==
<ul>
<li>SET HEAD OFF</li>
<li>SET FEED OFF</li>
<li>SET PAGESIZE 0</li>
<li>SET LINESIZE 200 (or whatever)</li>
</ul>

Revision as of 16:11, 21 April 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);

Setting Up a Clean Output for long Spools from SQL*Plus

  • SET HEAD OFF
  • SET FEED OFF
  • SET PAGESIZE 0
  • SET LINESIZE 200 (or whatever)