How to retrieve tablespace default storage Parameters? SELECT TABLESPACE_NAME "TABLESPACE", INITIAL_EXTENT "INITIAL_EXT", NEXT_EXTENT "NEXT_EXT", MIN_EXTENTS "MIN_EXT", MAX_EXTENTS "MAX_EXT", PCT_INCREASE FROM DBA_TABLESPACES;TABLESPACE INITIAL_EXT NEXT_EXT MIN_EXT MAX_EXT…
A tablespace is a logical storage unit. Why we are say logical because a tablespace is not visible in the file system. Oracle store data…
Before commit, Oracle Database keeps records of actions of transaction because Oracle needs this information to rollback or Undo the Changes. What is the main…
First we will discus about use of temporary tablespace. We use it to manage space for database sort operation. For example: if we join two…
Redo logs consists of two or more pre allocated files that store all changes made to the database. Every instance of an Oracle database has…
A control file is a small binary file that records the physical structure of the database with database name, Names and locations of associated datafiles,…
Important : Oracle does not provide an interface for dropping datafiles in the same way you would drop a schema object such as a table…
What is data File? Data files are physical files of the OS that store the data of all logical structures in the database. Data file…
Please confirm you want to block this member.
You will no longer be able to:
Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.
