| Split up a large datafile [message #169516] |
Thu, 27 April 2006 07:12  |
wmanbik
Messages: 1
Registered: April 2006
Location: Denmark
|
Junior Member |
|
|
I have a database with a large datafile on 8,4 GB, which makes our backup fail. I can't shrink the file more than 10 mb or so.
Is there any way i can split this file up without doing a export/recreated datafile/import. The database i very large, so
it would take like 2 days to do that.
The database is a oracle 9.2.0.5 and running on AIX 5.2 platform.
Thanks
Anders
|
|
|
|
| Re: Split up a large datafile [message #169518 is a reply to message #169516] |
Thu, 27 April 2006 07:22  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>> a large datafile on 8,4 GB, which makes our backup fail
That is a different issue and in administrative point of view, this is the root issue and you need to address this.
To answer your question, yes.
You can export and import or just move table/indexes to a different tablespace.
sql> alter table table_name move tablespace tablespace_name ;
will move the table to another tablespace.
Similarly rebuild the indexes in another tablespace.
First precreate the tablespace.
You cannot explicitly control which table/index goes to which datafile. You can control only in tablespace level.
Please search forum / documentation / google for more information.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
