Home » RDBMS Server » Server Administration » DB Restart after Table Partition (12c)
DB Restart after Table Partition [message #636376] Wed, 22 April 2015 08:50 Go to next message
karthik4u
Messages: 36
Registered: September 2006
Location: CHENNAI
Member
Hi All,

Whether we need to restart DB after Table Partition?

Thanks
Re: DB Restart after Table Partition [message #636379 is a reply to message #636376] Wed, 22 April 2015 09:03 Go to previous messageGo to next message
BlackSwan
Messages: 25858
Registered: January 2009
Location: SoCal
Senior Member
karthik4u wrote on Wed, 22 April 2015 06:50
Hi All,

Whether we need to restart DB after Table Partition?

Thanks

NO


Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/
Re: DB Restart after Table Partition [message #636380 is a reply to message #636376] Wed, 22 April 2015 09:04 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3123
Registered: May 2013
Location: World Wide on the Web
Senior Member
Why do you think so? Or, what is the reason behind your thoughts?

And what does table partition actually mean here? CREATE or DROP? Or what? I mean ....

[Updated on: Wed, 22 April 2015 09:05]

Report message to a moderator

Re: DB Restart after Table Partition [message #636382 is a reply to message #636380] Wed, 22 April 2015 09:09 Go to previous messageGo to next message
karthik4u
Messages: 36
Registered: September 2006
Location: CHENNAI
Member
Thanks BlackSwan.

Lalit, it is partitioning a table with CREATE TABLE command. I know that no need to restart DB after table partition.

But guys around confused me as usual Wink

Thanks
Re: DB Restart after Table Partition [message #636383 is a reply to message #636382] Wed, 22 April 2015 09:09 Go to previous messageGo to next message
karthik4u
Messages: 36
Registered: September 2006
Location: CHENNAI
Member
But guys around me confused me as usual Wink
Re: DB Restart after Table Partition [message #636384 is a reply to message #636383] Wed, 22 April 2015 09:12 Go to previous messageGo to next message
BlackSwan
Messages: 25858
Registered: January 2009
Location: SoCal
Senior Member
karthik4u wrote on Wed, 22 April 2015 07:09
But guys around me confused me as usual Wink


what prevents you from conducting actual test to just see what happens yourself?????????????////
Re: DB Restart after Table Partition [message #636386 is a reply to message #636383] Wed, 22 April 2015 09:13 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3123
Registered: May 2013
Location: World Wide on the Web
Senior Member
Don't just LISTEN to the guys around you. Test it yourself, and SHOW the guys they are wrong. You will go miles ahead them when you do so. Trust me, if you are in IT(fortunate enough to have test environment).
Re: DB Restart after Table Partition [message #636388 is a reply to message #636386] Wed, 22 April 2015 09:26 Go to previous messageGo to next message
EdStevens
Messages: 902
Registered: September 2013
Senior Member
Lalit Kumar B wrote on Wed, 22 April 2015 09:13
Don't just LISTEN to the guys around you. Test it yourself, and SHOW the guys they are wrong. You will go miles ahead them when you do so. Trust me, if you are in IT(fortunate enough to have test environment).


No need to depend on the IT organization to provide a test environment. The OP should create his own with VBox. see: http://edstevensdba.wordpress.com/category/opinion/ (Create your own test system)


Edit : As Gazzag pointed out, this is the correct link https://edstevensdba.wordpress.com/2011/06/02/create-your-own-test-system/

[Updated on: Wed, 22 April 2015 09:52] by Moderator

Report message to a moderator

Re: DB Restart after Table Partition [message #636389 is a reply to message #636388] Wed, 22 April 2015 09:35 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3123
Registered: May 2013
Location: World Wide on the Web
Senior Member
Thanks Ed.
Re: DB Restart after Table Partition [message #636390 is a reply to message #636388] Wed, 22 April 2015 09:35 Go to previous messageGo to next message
gazzag
Messages: 909
Registered: November 2010
Location: Bristol, UK
Senior Member
Ed, your link is slightly off. OP should probably use this one.
Re: DB Restart after Table Partition [message #636400 is a reply to message #636390] Wed, 22 April 2015 14:17 Go to previous messageGo to next message
EdStevens
Messages: 902
Registered: September 2013
Senior Member
gazzag -

That's strange. For the life of me I can't find any difference, but your link works and mine doesn't. In Firefox I've done a 'copy link location' on both, pasted both into notepad, one on top of the other, and absolutely see no difference.
Re: DB Restart after Table Partition [message #636401 is a reply to message #636400] Wed, 22 April 2015 14:54 Go to previous messageGo to next message
Michel Cadot
Messages: 65389
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

For me, your link works with FF but not with IE!
Note that with FF it is automatically converted to https and so if I directly use https with IE it works.


Re: DB Restart after Table Partition [message #636407 is a reply to message #636400] Thu, 23 April 2015 00:08 Go to previous message
Lalit Kumar B
Messages: 3123
Registered: May 2013
Location: World Wide on the Web
Senior Member
Actually, your link points to the category "opinion", in which the post "create your own test system" is the second post. So, the first post "plagiarism" shows up on top. The link which gazzag pointed to, directly opens the post.

So, one is the link to the category, the other is direct link to the post. That's all the difference I could make out.

[Updated on: Thu, 23 April 2015 00:09]

Report message to a moderator

Previous Topic: prevent high cost queries
Next Topic: ITL wait events for indexes
Goto Forum:
  


Current Time: Sat Feb 24 16:40:44 CST 2018

Total time taken to generate the page: 0.01321 seconds