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".
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:
No comments:
Post a Comment