PL/SQL (MOSC)

MOSC Banner

Adding ";" to DBMS_METADATA_DIFF.COMPARE_ALTER output

edited Sep 15, 2009 11:06PM in PL/SQL (MOSC) 4 commentsAnswered
Try this:

CREATE TABLE t1 ( sr number(10), sdata VARCHAR2(30) );
CREATE TABLE t2 ( sr number(9) not null, sdata1 VARCHAR2(20), sdatax CLOB );

set long 20000
col cmd form a132 word_wrapped
select dbms_metadata_diff.compare_alter ( 'TABLE', 'T1', 'T2', USER, USER ) cmd from dual;

Result:

ALTER TABLE "TESTSR"."T1" ADD ("SDATA1" VARCHAR2(20))
ALTER TABLE "TESTSR"."T1" ADD ("SDATAX" CLOB) LOB ("SDATAX") STORE AS BASICFILE  ( TABLESPACE "MATCHING_DATA" ENABLE STORAGE IN ROW
CHUNK 8192 RETENTION  NOCACHE LOGGING STORAGE( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS

1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))
ALTER TABLE "TESTSR"."T1" DROP ("SDATA")
ALTER TABLE "TESTSR"."T1" MODIFY ("SR" NUMBER(9,0))

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center