Oracle DBA Support

Search This Blog

Drop database in Oracle

March 31, 2025

Get link
Facebook
X
Pinterest
Email
Other Apps

Drop database in Oracle

*
ERROR at line 1:
ORA-12719: operation requires database is in RESTRICTED mode

STARTUP NOMOUNT RESTRICT;

alter database mount;

drop database;

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Kill user session in Oracle Database

Kill user session in Oracle Database select 'alter system kill session '''||sid||','||serial#|| ''' immediate;' from v$session where osuser='&username';

How to use log miner in Oracle Database

How to use log miner in Oracle Database SELECT * FROM V$ARCHIVED_LOG WHERE FIRST_CHANGE# <= 12435785206731 AND NEXT_CHANGE# >= 12435785206731; EXECUTE DBMS_LOGMNR.ADD_LOGFILE( - LOGFILENAME => 'arch file', - OPTIONS => DBMS_LOGMNR.NEW); EXECUTE DBMS_LOGMNR.START_LOGMNR( - OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG); SELECT username AS USR, (XIDUSN || '.' || XIDSLT || '.' || XIDSQN) AS XID, SQL_REDO, SQL_UNDO FROM V$LOGMNR_CONTENTS where XIDUSN=49 and XIDSLT=25 and XIDSQN=22415431; EXECUTE DBMS_LOGMNR.END_LOGMNR();

How to get Oracle database directories details

Get Oracle Database directories details SQL> desc dba_directories; Name Null? Type ----------------------------------------- -------- ---------------------------- OWNER NOT NULL VARCHAR2(128) DIRECTORY_NAME NOT NULL VARCHAR2(128) DIRECTORY_PATH VARCHAR2(4000) ORIGIN_CON_ID NUMBER set linesize 190 col owner for a30 col ...

Powered by Blogger

Drop database in Oracle

Drop database in Oracle

Comments

Post a Comment