ORACLE: DBA's day out
A blog about Oracle administration and configuration.
Sunday, May 6, 2007
Restrict performing DDL in a Schema
›
To restrict Schema owner/user to perform any kind of DDL, the following TRIGGER can be useful: CREATE OR REPLACE TRIGGER trigger_name BEFORE...
Saturday, April 28, 2007
Brought back deleted datafile
›
It is possible to brought back deleted datafile. To see how : SQL> CREATE TABLESPACE test DATAFILE '/backup2/test_01.dbf' SIZE 10...
‹
›
Home
View web version