Wednesday, 16 April 2014

Creating a Tablespace in oracle10g



Creating-Tablespaces Step by Step :
First of all, Go to Start=>All Programs=> OraDb10g_home1=> Database Control-MyOracle and specifying the system username and password after that we will click Login button.
Step1:
The Database Instance page is displaying and we will click Administration tab.

Step2:
The Administration page is displaying. We will click Tablespace option and tablespace is the part of the storage and under of the database administration.


Step3:
 The Tablespace page is displaying and we will click Create button.
Step4
The Create Tablespace page is displaying. We will enter name of the tablespace. Click Add button.

Step5
 The Add Datafile page is displaying. We will enter file name, directory, tablespace name by default and file size set. We will set storage and click Continue.

Step6
The tablespace has been created .
Step7
Click OK . The Update Message page is displaying. This page show the message "The object has benn created successfully".
Step8:
Logout and Login as Scott in sqlplus/isqlplus/sqlcommand-prompt.
Create a table:
Create table tablename(fieldname1 datatype1,fieldname2 datatype2,fieldname3 datatype3,-----) tablespace tablespacename;



Bring a Tablespace Online:
SYNTAX:

ALTER TABLESPACE tablespacename ONLINE;
Bring a Tablespace offline:
Syntax:
ALTER TABLESPACE tablespacename offline;




No comments:

Post a Comment