SET SERVEROUTPUT ON In SQLPLUS is displaying other DDL statements (Doc ID 1533717.1)

Last updated on DECEMBER 06, 2016

Applies to:

SQL*Plus - Version 10.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Unknown DDL statements appears when executing a DDL with "SET SERVEROUTPUT ON"

For Example

The following statements appears in the output after setting "SET SERVEROUTPUT ON"

SQL> alter index <index_name> rebuild online compute statistics;
alter index <index_name> rebuild online compute statistics
create table "SYS_JOURNAL_<number>" (<column[,column,..]>) organization index
TABLESPACE <tablespace_name>
CREATE UNIQUE INDEX "SYS_IOT_TOP_<number>" on
"SYS_JOURNAL_<number>"(<column[,column,..]>) INDEX ONLY
TOPLEVEL TABLESPACE <tablespace_name> STORAGE( BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT) NOPARALLEL
drop table "SYS_JOURNAL_<number>" purge

The output may vary depend on th index structure or the DDL used.



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms