select 'alter table ' || table_name || ' move tablespace your_target_tablespace_name ;' from user_tables;
Thursday, August 15, 2013
How to Move tables from one tablespace to another in oracle
select 'alter table ' || table_name || ' move tablespace your_target_tablespace_name ;' from user_tables;
Wednesday, July 10, 2013
Resizing Temporary Tablespace
SELECT tablespace_name, file_name, bytes FROM dba_temp_files WHERE tablespace_name = 'TEMP';
ALTER DATABASE TEMPFILE '/u02/oracle/data/temp02.dbf' RESIZE 18M;
Friday, May 17, 2013
How to find out Which User is in Oracle database?
SELECT
SUBSTR(SS.USERNAME,1,8) USERNAME,
SS.OSUSER "USER",
AR.MODULE || ' @ ' || SS.machine CLIENT,
SS.PROCESS PID,
TO_CHAR(AR.LAST_LOAD_TIME, 'DD-Mon HH24:MM:SS') LOAD_TIME,
AR.DISK_READS DISK_READS,
AR.BUFFER_GETS BUFFER_GETS,
SUBSTR(SS.LOCKWAIT,1,10) LOCKWAIT,
W.EVENT EVENT,
SS.status,
AR.SQL_fullTEXT SQL
FROM V$SESSION_WAIT W,
V$SQLAREA AR,
V$SESSION SS,
v$timer T
WHERE SS.SQL_ADDRESS = AR.ADDRESS
AND SS.SQL_HASH_VALUE = AR.HASH_VALUE
AND SS.SID = w.SID (+)
AND ss.STATUS = 'ACTIVE'
AND W.EVENT != 'client message'
ORDER BY SS.LOCKWAIT ASC, SS.USERNAME, AR.DISK_READS DESC
SUBSTR(SS.USERNAME,1,8) USERNAME,
SS.OSUSER "USER",
AR.MODULE || ' @ ' || SS.machine CLIENT,
SS.PROCESS PID,
TO_CHAR(AR.LAST_LOAD_TIME, 'DD-Mon HH24:MM:SS') LOAD_TIME,
AR.DISK_READS DISK_READS,
AR.BUFFER_GETS BUFFER_GETS,
SUBSTR(SS.LOCKWAIT,1,10) LOCKWAIT,
W.EVENT EVENT,
SS.status,
AR.SQL_fullTEXT SQL
FROM V$SESSION_WAIT W,
V$SQLAREA AR,
V$SESSION SS,
v$timer T
WHERE SS.SQL_ADDRESS = AR.ADDRESS
AND SS.SQL_HASH_VALUE = AR.HASH_VALUE
AND SS.SID = w.SID (+)
AND ss.STATUS = 'ACTIVE'
AND W.EVENT != 'client message'
ORDER BY SS.LOCKWAIT ASC, SS.USERNAME, AR.DISK_READS DESC
How to rebuild index in oracle
SELECT 'ALTER INDEX ' || a.index_name || ' REBUILD;'
FROM all_indexes a
WHERE table_owner = Upper('TEST')
Sunday, May 5, 2013
Expected Results
Expected Results
Karnataka Board Of Pre-University Education
Karnataka PUC Result (Class 12) | Expected on 06 May, 2013
Karnataka Board Of Secondary Education
Karnataka SSLC Result (Class 10) | Expected on 06 May, 2013Saturday, May 4, 2013
Friday, April 19, 2013
LOCATE ANY POST OFFICE/Pincode IN INDIA
LOCATE ANY POST OFFICE/Pincode IN INDIA
(Select State then District then Post Office to see Pincode Details)
http://pincode.net.in/
(Select State then District then Post Office to see Pincode Details)
http://pincode.net.in/
Subscribe to:
Posts (Atom)