How To View the Tablespaces in the Current Database

Q

How To View the Tablespaces in the Current Database? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files

✍: FYIcenter.com

A

If you want to get a list of all tablespaces used in the current database instance, you can use the DBA_TABLESPACES view as shown in the following SQL script example:

SQL> connect SYSTEM/fyicenter
Connected.

SQL> SELECT TABLESPACE_NAME, STATUS, CONTENTS
  2  FROM USER_TABLESPACES;
TABLESPACE_NAME                STATUS    CONTENTS
------------------------------ --------- ---------
SYSTEM                         ONLINE    PERMANENT
UNDO                           ONLINE    UNDO
SYSAUX                         ONLINE    PERMANENT
TEMP                           ONLINE    TEMPORARY
USERS                          ONLINE    PERMANENT

2007-05-03, 5075👍, 0💬

How To List All Tables in Your Schema
How To List All Tables in Your Schema? - Oracle DBA FAQ - Managing Oracle Database Tables If you log in with your Oracle account, and you want to get a list of all tables in your schema, you can get it through the USER_TABLES view with a SELECT statement, as shown in the following SQL script: SQL> c... 2007-05-04, 5217👍, 0💬

How To View the Tablespaces in the Current Database
How To View the Tablespaces in the Current Database? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If you want to get a list of all tablespaces used in the current database instance, you can use the DBA_TABLESPACES view as shown in the following SQL script example: SQL> connect SYSTE... 2007-05-03, 5076👍, 0💬

What Is an Oracle Data File
What Is an Oracle Data File? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files An Oracle data file is a big unit of physical storage in the OS file system. One or many Oracle data files are organized together to provide physical storage to a single Oracle tablespace. 2007-05-04, 4979👍, 0💬

What Is an Oracle Tablespace
What Is an Oracle Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files An Oracle tablespace is a big unit of logical storage in an Oracle database. It is managed and used by the Oracle server to store structures data objects, like tables and indexes. 2007-05-04, 4977👍, 0💬

How To Rename a Tablespace
How To Rename a Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files You can easily rename a tablespace by using the ALTER TABLESPACE ... RENAME TO statement as shown in the example below: SQL> CREATE TABLESPACE my_space 2 DATAFILE '/temp/my_space.dbf' SIZE 10M; Tablespace creat... 2007-05-03, 4940👍, 0💬

How To View the Data Files in the Current Database
How To View the Data Files in the Current Database? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If you want to get a list of all tablespaces used in the current database instance, you can use the DBA_TABLESPACES view as shown in the following SQL script example: SQL> connect SYSTEM... 2007-05-03, 4934👍, 0💬

How a Tablespace Is Related to Data Files
How a Tablespace Is Related to Data Files? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files Each tablespace in an Oracle database consists of one or more files called datafiles, which are physical structures that conform to the operating system in which Oracle is running. 2007-05-03, 4933👍, 0💬

How To Create a New Tablespace
How To Create a New Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If you want a new dataspace, you can use the CREATE TABLESPACE ... DATAFILE statement as shown in the following script: SQL> CREATE TABLESPACE my_space 2 DATAFILE '/temp/my_space.dbf' SIZE 10M; Tablespace c... 2007-05-03, 4933👍, 0💬

How a Database Is Related to Tablespaces
How a Database Is Related to Tablespaces? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files A database's data is collectively stored in the datafiles that constitute each tablespace of the database. For example, the simplest Oracle database would have one tablespace and one datafile. Ano... 2007-05-03, 4899👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.