Archives for Oracle database - Page 2
ORA-12537: TNS:connection closed
Giving below error when trying to connect oracle user ERROR: Sqlplus scott/tiger@PROD SQL*Plus: Release – Production on Thu Oct 16 15:06:46 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved.…
CHECK TABLESPACE SIZE, FREE AND USED SPACE
Below query is used for finding total tablespace size and free, used space. select tablespace_name, ROUND(bytes_free,2) free,ROUND(bytes_total-bytes_free,2) used, ROUND(bytes_total,2) total,perused from (select , ,, ROUND((100-(100*)),2) perused from (Select tablespace_name,sum(bytes)/1024/1024 bytes_free…
DROP DATABASE THROUGH RMAN
In Oracle Database 10gR1 Oracle introduced the RMAN command DROP DATABSE. This one simple statement has the ability to completely remove a database including all RMAN backups with the optional…
Drop temp tablespace taking long time
Created new temporary tablespace: CREATE TEMPORARY TABLESPACE TEMP01 TEMPFILE ‘/u01/oracle/#8217; SIZE 2g; Make new temporary tablespace as default: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP01; Dropping old temporary tablespace, Which is…
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.…
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”…