Monthly Archives: August 2013

My first Oracle cloud application using oracle cloud trail account

I have tested Oracle cloud application using oracle cloud trail account.Steps are given below 1.go to¬†https://cloud.oracle.com/, login with your OTN account and request a trial period.need credit card for verification, but it will not get charged. 2.Download Oracle SQL Developer from below link http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html 3.To start SQL Developer, run sqldeveloper.exe. 4.Log in to APEX. Once […]

Some Tips on Oracle Table space and Users

–List all users/schema SELECT DISTINCT USERNAME FROM DBA_USERS; SELECT * FROM DBA_USERS; –List ONLY your tables SELECT * FROM CAT; SELECT * FROM TAB; –List the Oracle Tablespaces SELECT * from v$TABLESPACE; –See your TABLESPACE SELECT * FROM ALL_TABLES WHERE TABLE_NAME = ‘BL_SESSION_EVENT_HIST’; SELECT TABLE_NAME, TABLESPACE_NAME, STATUS FROM USER_TABLES; –find table space of all tables […]