Monthly Archives: July 2016

SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.

PROBLEM : Connecting with sqlplus you get: bash-3.2$ sqlplus / as sysdba; SQL*Plus: Release Production on Thu Jul 21 15:42:49 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release – 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> conn […]


select ‘ alter table ‘||table_name|| ‘ enable novalidate constraint ‘ ||constraint_name ||’;’ from user_constraints where table_name =’TABLE_NAME’

create a new user (with privs) like an existing

set pages 0 feed off veri off lines 500 accept oldname prompt “Enter user to model new user to: ” accept newname prompt “Enter new user name: ” — accept psw prompt “Enter new user’s password: ” — Create user… select ‘create user &&newname identified by values ”’||password||””|| — select ‘create user &&newname identified by […]