tablespace

Script for Tablespace current utilization. Script to add datafiles in tablespace. Script to resize datafiles. Script to Create tablespace Script to check temp tablespace utilization Script to add tempfile space in temp tablespace. Auto Extend DATAFILE Alter datafile auto extend on Disable autoextend of datafile. Create tabelspace with Autoextend on Create Big file tablespace. Check […]

In this post I will be describe about how we can assign the oracle tablespace to user. While creating oracle user we need to assign the tablespace to user. there are two kind of tablespace can be assign to oracle user. Default tablespace Temporary tablespace Following is the way to assign oracle tablspaces. SQL> ALTER […]

Check UNDO tablespace usage SELECT file_name, tablespace_name, bytes/1024/1024 UNDO_SIZE_MB, SUM (bytes/1024/1024) OVER() TOTAL_UNDO_SIZE_MB FROM dba_data_files d WHERE EXISTS (SELECT 1 FROM v$parameter p WHERE LOWER (p.name)=’undo_tablespace’ AND p.value=d.tablespace_name); Add datafile to undo tablespace ALTER TABLESPACE UNDOTBS1 ADD DATAFILE E:\APP\ANKUSH\ORADATA\MYDB\UNDOTBS02.DBF’ size 10M; Query to see Current Temp Datafiles State set pages 999 set lines 400 col […]