How To Rename a Tablespace

Q

How To Rename a Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files

✍: FYIcenter.com

A

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 created.

SQL> ALTER TABLESPACE my_space RENAME TO your_space;
Tablespace created.

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
YOUR_SPACE       ONLINE          PERMANENT

2007-05-03, 5199👍, 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, 5366👍, 0💬

What Happens to the Data Files If a Tablespace Is Dropped
What Happens to the Data Files If a Tablespace Is Dropped? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If a tablespace is dropped, what happens to its data files? By default, data files will remain in OS file system, even if the tablespace they are mapped is dropped. Of course, you... 2007-05-03, 5334👍, 0💬

How To Create a Table in a Specific Tablespace
How To Create a Table in a Specific Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files After you have created a new tablespace, you can give it to your users for them to create tables in the new tablespace. To create a table in a specific tablespace, you need to use the TABLES... 2007-05-03, 5224👍, 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, 5214👍, 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, 5200👍, 0💬

How To See Free Space of Each Tablespace
How To See Free Space of Each Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files One of the important DBA tasks is to watch the storage usage of all the tablespaces to make sure there are enough free space in each tablespace for database applications to function properly. Free... 2007-05-03, 5189👍, 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, 5171👍, 0💬

How To Drop a Tablespace
How To Drop a Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If you have an existing tablespace and you don't want it anymore. You can delete a tablespace by using the DROP TABLESPACE statement as shown in the example below: SQL> CREATE TABLESPACE my_space 2 DATAFILE '/tem... 2007-05-03, 5097👍, 0💬

How To Bring a Tablespace Offline
How To Bring a Tablespace Offline? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files If you want to stop users using a tablespace, you can bring it offline using the ALTER TABLESPACE ... OFFLINE statement as shown in the following script: SQL> connect HR/fyicenter Connected. SQL> CREATE ... 2007-05-03, 5044👍, 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.