Oracle Database - How To Create Additional Tablespaces for an New Database
Interview Question Database For Software Developers
|
|
| How To Create Additional Tablespaces for an New Database | | How To Create Additional Tablespaces for an New Database? - Oracle DBA FAQ - Creating New Database Instance Manually | | By: FYIcenter.com | This is Step 8. Creating additional tablespaces can be done by using the CREATE TABLESPACE statement
as shown in the following sample script:
SQL> CREATE TABLESPACE users
2 DATAFILE '/oraclexe/oradata/FYI/users01.dbf' SIZE 10M;
SQL> CREATE TABLESPACE indx
2 DATAFILE '/oraclexe/oradata/FYI/indx01.dbf' SIZE 10M;
| | ID: 516 | Rank: 1073 | Votes: 0 | Views: 27 | Submitted: 20070423 |
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.
|
|
|
Atom feed
List view