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

✍: 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;

2007-04-23, 4839👍, 0💬

Popular Posts:

Where are all .NET C...

Where are all .NET Collection classes located ? System.Collection namespace has all the collection c...

How is normally a pr...

How is normally a project management plan document organized ? PMP document forms the bible of a pro...

Using scriptlet to I...

How do I use a scriptlet to initialize a newly instantiated bean? A jsp:useBean action may optionall...

Can you explain dupl...

Can you explain duplex contracts in WCF? In duplex contracts when client initiates an operation the ...

How To Join a List o...

How To Join a List of Keys with a List of Values into an Array? - PHP Script Tips - PHP Built-in Fun...