OraFAQ Forum: Server Administration » Split/Link from one DBF to another new DBF

Home » RDBMS Server » Server Administration » Split/Link from one DBF to another new DBF (Tablespace Increase)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Split/Link from one DBF to another new DBF [message #273297]

Tue, 09 October 2007 22:11

kumarvk
Messages: 214
Registered: July 2004

Senior Member

Hi Experts,

I am having a tablespace/dbf which the size is 8GB now I want to spit this into two as 4GB each. How to do it? Please kindly help me. I think there is no need to keep on increasing the tablepsace/dbf when it is nearing the target and it is danger also.

My version of Oracle is 8i and release 8.1.7.

Can anyone help me in this regard?

[Updated on: Tue, 09 October 2007 22:13]

Report message to a moderator

Re: Split/Link from one DBF to another new DBF [message #273299 is a reply to message #273297]

Tue, 09 October 2007 22:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How to do it?
Can't be done (in 8.1.7).

The best you can do is add another datafile to this tablespace.

Report message to a moderator

Re: Split/Link from one DBF to another new DBF [message #273328 is a reply to message #273297]

Wed, 10 October 2007 00:12

d.c.b.a
Messages: 44
Registered: March 2005
Location: China

Member

1, you can export the tables on this tablespace, then drop the tablespace, recreate it with two or more smaller data files, and them import it.

2, If the tablespace is LMT mode, you can add a new datafile to this tablespace, then move some tables, then try to resize the first data file to smaller one.

Report message to a moderator

Re: Split/Link from one DBF to another new DBF [message #273336 is a reply to message #273297]

Wed, 10 October 2007 01:08

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

now I want to spit this into two

Create 2 new tablespaces, move the table to them as you want (alter table move) and drop tbe old tablespace.

Regards
Michel

Report message to a moderator

Previous Topic:	Why do they know about the space of leaf block?
Next Topic:	Error - Invalid staging area

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 07:34:44 CST 2024