Oracle Storage - How To Create a Table in a Specific Tablespace
Interview Question Database For Software Developers
|
|
| 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 | | By: 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
...
| | ID: 681 | Rank: 1060 | Votes: 0 | Views: 26 | Submitted: 20070503 |
1047 :-) | | How To Drop a Tablespace | | How To Drop a Tablespace? - Oracle DBA FAQ - Managing Oracle Tablespaces and Data Files... | | Submitted: 20070503 |
|
Copyright © 2009 FYIcenter.com
All rights in the contents of this Website are reserved by the individual author.
No part of the contents may be reproduced in any form without author's permission.
|
|
|