| Neeraj |
Posted: Dec 18, 2007 01:29:10 AM |
Total Post: 243
Joined: Jan, 2007
|
HI,
I M USING ORACLE 10G RAC ON AIX, I HAV E CREATED A TABLESPACE OF 50 GB , NOW I WANT TO REDUSE THE SIZE OF TABLRESPACE TILL 25 GB , TABLESPACE HAS 4 DATAFILES & ALL DATFILES ARE BEING USED,
SO TELL HOW CAN I REDUSE SIZE OF THE TABLESPACE WITOUT LOSSING ANY DATA.
THXS |
|
|
 Murtuja |
| Posted: Dec 18, 2007 03:30:47 AM |  |
|
Total Post: 816
Joined: Jan, 2006
|
First of all,Posting your query in multiple sections is really bad manner.It seems you don't respect this forum also.You need to learn NETIQUETTE "network etiquette".
Anyway you can do it without loosing any data.
ALTER DATABASE DATAFILE 'filename1' RESIZE 5GB;
ALTER DATABASE DATAFILE 'filename2' RESIZE 5GB;
ALTER DATABASE DATAFILE 'filename3' RESIZE 5GB;
ALTER DATABASE DATAFILE 'filename4' RESIZE 5GB;
|
|
|
|
|
| Neeraj |
| Posted: Dec 18, 2007 04:34:16 AM | |
|
Total Post: 243
Joined: Jan, 2007
|
hi,
thxs for replying me, but its on datafile lavel, is there any method that i can resize my tablespace by 1 syntax of tablespace level not datfile lavel.
or can i transfer my datafile's data into another data file of same tablespace.means can i reduse no. of datafile of my tablespace w/o loosing data.
|
|
|
|
|
| Babu |
| Posted: Dec 18, 2007 05:49:05 AM | |
|
Total Post: 94
Joined: Oct, 2007
|
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14231/dfiles.htm
|
|
|
|
|
| Murtuja |
| Posted: Dec 18, 2007 08:12:44 AM | |
|
Total Post: 816
Joined: Jan, 2006
|
create another tablespace
move all the tables and indexes
drop the old tablespace
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
