| Tablespace [message #51853] |
Tue, 18 June 2002 00:27  |
mayur
Messages: 10
Registered: November 2001
|
Junior Member |
|
|
|
How to increase the size of table space in oracle
|
|
|
|
| Re: Tablespace [message #51854 is a reply to message #51853] |
Tue, 18 June 2002 02:11  |
K.SREENIVASAN
Messages: 110
Registered: January 2001
Location: banglore
|
Senior Member |
|
|
SIR,
YOU CAN GIVE THE FOLLOWING COMMAND
IF YOU WANT TO INCREASE THE SIZE ,YOU CAN A DATAFILE TO YOUR TABLESPACE OR RESIXE THE EXISTING DATAFILE.
(NOTE : YOU CAN'T REDUSE THE SIZE OF DATAFILE.)
ALTER TABLESPACE USER_DATA ADD DATAFILE 'Ç:ORACLEDATABASEUSER2.ORA 500M;
RESIZE THE EXISTING DATAFILE
ALTER TABLESPACE USER_DATA DATAFILE 'Ç:ORACLEDATABASEUSER2.ORA RESIZE 500M;
K.SREENIVASAN
|
|
|
|
| Re: Tablespace [message #53377 is a reply to message #51853] |
Mon, 16 September 2002 23:38 |
Abdul Sami
Messages: 1
Registered: September 2002
|
Junior Member |
|
|
hi,
i m computer student n i want to apear in the DBA
Exams here at Sindh University.
so i need some notes on oracle, thru which i could
be prepared for that..
plz reply to me
as soon as possible
thanx
ASM
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
