Home » RDBMS Server » Server Administration » Autoextend on/off ?
Autoextend on/off ? [message #250104] Sat, 07 July 2007 22:58 Go to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I have tablespace named 'prothoma'. Under it there is only 1 datafile prothoma01.dbf and under it there are about 100 tables . The size of it is about 11 G.Now I first wanna create a tablespace prothoma in which I will mention size 1G+ Autoextend on. And I will import all tables into it.After importing data into it I wanna make autoextend off. Will there create any problem?

-What are the consequences may happen?
Re: Autoextend on/off ? [message #250105 is a reply to message #250104] Sat, 07 July 2007 23:04 Go to previous messageGo to next message
BlackSwan
Messages: 25049
Registered: January 2009
Location: SoCal
Senior Member
Why are you considering doing this?
Re: Autoextend on/off ? [message #250293 is a reply to message #250104] Mon, 09 July 2007 08:57 Go to previous messageGo to next message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
You have a tablespace named prothoma and you want to create a new tablespace called prothoma. This cannot be done in Oracle.
Re: Autoextend on/off ? [message #250406 is a reply to message #250104] Mon, 09 July 2007 23:45 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Sorry, I put the wrong post. I actually want to say if I make autoextend on and define tablespace size 1 MB. And I imported data in this tablespace. Later when its size grows to 1GB. I , then alter tablespace size to 100M. What will happen then?
Re: Autoextend on/off ? [message #250428 is a reply to message #250104] Tue, 10 July 2007 00:52 Go to previous messageGo to next message
BlackSwan
Messages: 25049
Registered: January 2009
Location: SoCal
Senior Member
> What will happen then?
A body at rest will stay at rest unless impacted by an external force.

So what problem are you REALLY trying to solve?
Re: Autoextend on/off ? [message #250472 is a reply to message #250406] Tue, 10 July 2007 03:15 Go to previous message
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
Obviously it'll give u an error and it cant resize.
Previous Topic: Port used by Oracle
Next Topic: TNS listener error please help
Goto Forum:
  


Current Time: Fri Dec 09 09:54:00 CST 2016

Total time taken to generate the page: 0.07642 seconds