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 11.2.0.4.0 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 11.2.0.4.0 – 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> conn […]
enable_novalidate_constraint
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 […]
anargodjaev.wordpress.com 