| ramesh |
Posted: Apr 10, 2008 02:39:15 AM |
Total Post: 69
Joined: Dec, 2006
|
i'm using oracle 9i on linux
i hav tablespace with 3 datafiles on the 1st partition,
and due to insufficient space in the tablespace and partition,
i added a datafile to it with the datafile on the 2nd partition,
now the tablespace show free space but the partition space is still full
it means the data is shared with the datafiles on the 1st partition.
what i want is to move some data from the 1st 3 datafiles to the 4th
so that the partition size will be freed.
..ramesh |
|
|
 Murtuja |
| Posted: Apr 10, 2008 03:17:40 AM |  |
|
Total Post: 816
Joined: Jan, 2006
|
You can not move data (objects) between datafiles within a tablespace.
So You need to follow some steps to free space in your partiotion.
see this link
http://www.jlcomp.demon.co.uk/faq/rename_datafile.html
|
|
|
|
|
| ramesh |
| Posted: Apr 10, 2008 05:02:33 AM | |
|
Total Post: 69
Joined: Dec, 2006
|
Hi. Murtuja
but i want only some part of data to another datafile
|
|
|
|
|
| Murtuja |
| Posted: Apr 10, 2008 05:59:53 AM | |
|
Total Post: 816
Joined: Jan, 2006
|
You have three datafile on first partition and one datafile on second partition.
First Partition
file#1
file#2
file#3
Second Partition
file#4
You have to take tablespace offline first.
move file#2 and file#3 to second partition (cut & paste in windows )
Then
alter tablespace tablespace_name rename datafile 'Partition1/file#2.dbf' TO 'Partition2/file#2.dbf' ;
alter tablespace tablespace_name online;
|
|
|
|
|
| Murtuja |
| Posted: Apr 10, 2008 06:00:35 AM | |
|
Total Post: 816
Joined: Jan, 2006
|
Please also note that you can not move data (objects) between datafiles within a tablespace.
|
|
|
|
|
| Murtuja |
| Posted: Apr 10, 2008 06:49:48 AM | |
|
Total Post: 816
Joined: Jan, 2006
|
any updates ? Please let us know that solution worked for you or not .
|
|
|
|
|
| ramesh |
| Posted: Apr 10, 2008 07:15:20 AM | |
|
Total Post: 69
Joined: Dec, 2006
|
Hi..
My issue is OS partition, my oracle does not start up unless all the partitions hav some 100ms free space.
now the problem is that i cannot move the datafile due 2 space scarcity.
so i think the final solution will be exporting full database.
again creating tablespace as per req'mnts and then importing.
means if i need want 2 use only 90% of the disk then i need to assign a datafile of that size on that partition and remaining on the other.
this way the data can be distributed among datafiles.
anyway thanks for the reply
|
|
|
|
|
| Murtuja |
| Posted: Apr 10, 2008 07:59:29 AM | |
|
Total Post: 816
Joined: Jan, 2006
|
You can free up space from partition.no need to export/import.Read my last answer carefully.
Your database is down rightnow.So you have to move some datafile to another partition then you have to mount database.
After mounting database use " ALTER DATABASE RENAME " commands
startup database
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
