HOW TO REMOVE STREAM 01. remove streams EXEC DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION(); 02. drop queue tables select OWNER,NAME,QUEUE_TABLE from dba_queues where owner=”; then exec DBMS_STREAMS_ADM.REMOVE_QUEUE(”); 03 drop supplemental logging select ‘alter table ‘||owner||’.’||table_name||’ drop supplemental log data (all) columns;’ from DBA_LOG_GROUPS where owner=”;

HOW TO SPLIT A SINGLE PARTITION INTO MULTIPLE PARTITIONS IN 12C  APPLIES TO: Oracle Database – Enterprise Edition – Version 12.1.0.1 and later – Information in this document applies to any platform. Oracle 12C supports splitting a partition into more

INSTALLATION OF ORACLE DATABASE Oracle Installation and Database Development On UNIX and Windows Platforms – A comparison UNIX Windows NT/2000/XP On UNIX, several files and scripts in different directories are used to start an instance automatically. Other scripts are run

INSTALLING ORACLE 11.2.0.4 ON X86 64 BIT LINUX RHEL – REQUIREMENTS? (FROM AND BY ORACLE) APPLIES TO: Oracle Database – Standard Edition – Version 11.2.0.4 to 11.2.0.4 [Release 11.2]Oracle Database – Enterprise Edition – Version 11.2.0.4 to 11.2.0.4 [Release 11.2]Linux

LOADING DATA INTO ORACLE TABLES ( sp_get_set_and_load ) This doc details the procedure evolved to automate the process of loading the data into Oracle database using SQL*Loader. The functionality of the procedure: (1) Go to the destination directory and get