Home » RDBMS Server » Server Administration » Split/Link from one DBF to another new DBF (Tablespace Increase)
Split/Link from one DBF to another new DBF [message #273297] Tue, 09 October 2007 22:11 Go to next message
kumarvk
Messages: 211
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 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
Re: Split/Link from one DBF to another new DBF [message #273328 is a reply to message #273297] Wed, 10 October 2007 00:12 Go to previous messageGo to next message
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.
Re: Split/Link from one DBF to another new DBF [message #273336 is a reply to message #273297] Wed, 10 October 2007 01:08 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Why do they know about the space of leaf block?
Next Topic: Error - Invalid staging area
Goto Forum:
  


Current Time: Thu Dec 08 12:47:18 CST 2016

Total time taken to generate the page: 0.05201 seconds