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?

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
Senior Member
Why are you considering doing this?

Report message to a moderator

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: 4963
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.

Report message to a moderator

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?

Report message to a moderator

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: 26766
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?

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Port used by Oracle
Next Topic: TNS listener error please help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:41:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.