Collections:
Create a Table in a Given Tablespace in Oracle
How To Create a Table in a Specific Tablespace in Oracle?
✍: FYIcenter.com
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 TABLESPACE clause in the CREATE TABLE statement. Here is a sample script:
SQL> connect SYSTEM/fyicenter Connected. SQL> CREATE TABLESPACE my_space 2 DATAFILE '/temp/my_space.dbf' SIZE 10M; Tablespace created. SQL> connect HR/fyicenter Connected. SQL> CREATE TABLE my_team TABLESPACE my_space 2 AS SELECT * FROM employees; Table created. SQL> SELECT table_name, tablespace_name, num_rows 2 FROM USER_TABLES 3 WHERE tablespace_name in ('USERS', 'MY_SPACE'); TABLE_NAME TABLESPACE_NAME NUM_ROWS ------------------------------ ---------------- ---------- MY_TEAM MY_SPACE - EMPLOYEES USERS 107 ...
⇒ Show Free Space in a Tablespace in Oracle
⇐ Keep Data Files When Tablespace Dropped in Oracle
2019-01-08, 2292👍, 1💬
Popular Posts:
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...