How to check default tablespace in oracle

SQL> SELECT * FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME LIKE '%TABLESPACE%';


PROPERTY_NAME                              PROPERTY_VALUE                DESCRIPTION
------------------------------ -------------------- ---------------------------------------------------------------
DEFAULT_TEMP_TABLESPACE                TEMP                  Name of default temporary tablespace
DEFAULT_PERMANENT_TABLESPACE   USERS               Name of default permanent tablespace



Happy Learning ....

How to Check Temp Tablespace Free Size in Oracle Database

SQL> SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
COL TABLESPACE_SIZE FOR 999,999,999,999
COL ALLOCATED_SPACE FOR 999,999,999,999
COL FREE_SPACE FOR 999,999,999,999
SELECT *  FROM   dba_temp_free_space;

Press Return to Continue

TABLESPACE       TABLESPACE_SIZE         ALLOCATED_SPACE             FREE_SPACE
---------- ---------------- ---------------- --------------------------------------------------------------------
TEMP                        39,460,012,032               39,269,171,200                39,457,914,880

Happy  Learning ....

DIM-00014 Cannot Open Windows NT Service Control Manager

Problem : When i am installing Oracle11g on Windows7 i faced this Error.

Solution : Very Simple Run dbca Utility with Administrator Option.


C:\app\moin>dbca

> I executed dbca with Administrator option from Oracle_Home/BIN location its run successfully.

> You can see in this screen-shot its installed 100% without any errors.

Happy Learning ...

How to Check Particular Schema Size in Oracle Database

SQL> select owner,sum(bytes)/1024/1024/1024 as "SIZE in GB" from dba_segments where owner='KIST' group by owner;

OWNER                          SIZE in GB
-----------------------------------------------------
KIST                               18.2417603

Happy Learning...