Database Actions (SQL Developer Web) (MOSC)

MOSC Banner

Queries skipped from the script

I faced one this problem in our production enviornment, same script run without any errors in other 3 test enviornments, but in the production recevied no ERROR message, but the effect of the queries not implemented in the tables.queries are on different lines in the script.

SQL> CREATE INDEX avg_pk ON avgor (id) TABLESPACE v_data_idx

SQL> ALTER TABLE ve.avgor DROP CONSTRAINT avg_pk

SQL> ALTER TABLE ve.avgor ADD CONSTRAINT avg_pk PRIMARY KEY (id)

SQL> ALTER TABLE ve.fry_avgor_dok ADD rat_sek_info CLOB

SQL> COMMENT ON COLUMN ve.fry_avgor_dok.rat_sek_info IS 'abc'

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