Archives for ORACLE DBA - Page 3
Find size of Table,Index and USER/SCHEMA in Oracle
How to find size of Table or Index or User/Schema in Oracle Database. SIZE OF TABLE: Select segment_name,sum(bytes)/1024/1024/1024 as “SIZE in GB” from user_segments where segment_name=’TABLE_NAME’ group by segment_name; OR…
Disable Case Sensitive in Oracle Database 11g
Prior to 11g Passwords in Oracle are not case sensitive. Now from 11g Oracle passwords are Case sensitive. Parameter sec_case_sensitive_logon has been included in Oracle 11g. sql> create user test…
ORA-12547 TNS: Lost Contact
Getting the following error when trying to connect using Sql*Plus ERROR: $sqlplus / as sysdba SQL*Plus: Release – Production on Wed Mar 30 11:59:06 2011 Copyright (c) 1982, 2008, Oracle.…
Delete expired archivelogs using RMAN
Below commands will helpful for deleting expired archivelog files through RMAN : RMAN>list expired archivelog all; RMAN>crosscheck archivelog all; RMAN>delete noprompt expired archivelog all; Now check the output with below…
Delete expired archivelogs using RMAN
Below commands will helpful for deleting expired archivelog files through RMAN : RMAN>list expired archivelog all; RMAN>crosscheck archivelog all; RMAN>delete noprompt expired archivelog all; Now check the output with below…
Delete expired archivelogs using RMAN
Below commands will helpful for deleting expired archivelog files through RMAN : RMAN>list expired archivelog all; RMAN>crosscheck archivelog all; RMAN>delete noprompt expired archivelog all; Now check the output with below…
ORA-01940: cannot drop a user that is currently connected
SQL>drop user MY_USER cascade; drop user username cascade * ERROR at line 1: ORA-01940: cannot drop a user that is currently connected SQL>select , #, , from v$session s, v$process…
ORA-39097 Data Pump job encountered unexpected error
ERROR: Export: Release – Production on Wednesday, 08 August, 2007 10:12:50 Copyright (c) 2003, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release – Production With…
ORA-39181: Only partial table data may be exported due to fine grain access control
The below error appeared when trying to export the Schema: ORA-39181: Only partial table data may be exported due to fine grain access control on “GLOGOWNER”.”WORKFLOW_ACTION_PARAM” . . exported “GLOGOWNER”.”WORKFLOW_ACTION_PARAM”…
DATABASE SCHEMA SIZE from the database
set linesize 150 set pagesize 5000 col owner for a155 select OWNER,sum(bytes)/1024/1024/1000 “SIZE_IN_GB” from dba_segments group by owner order by owner; Thank you !!