Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
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
✍: 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 ...
2007-05-03, 4672👍, 0💬
Popular Posts:
What will happen in these three cases? if (a=0) { //somecode } if (a==0) { //do something } if (a===...
How Are Vertical Margins between Two Block Elements Collapsed? - CSS Tutorials - Understanding Multi...
How To Enter Numeric Values as HEX Numbers? - MySQL FAQs - Introduction to SQL Basics If you want to...
How to set a HTML document's background color? document.bgcolor property can be set to any appropria...
How To Export Data to an XML File? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you wa...