OraFAQ Forum: Server Administration » DB Restart after Table Partition

Home » RDBMS Server » Server Administration » DB Restart after Table Partition (12c)

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

DB Restart after Table Partition [message #636376]

Wed, 22 April 2015 08:50

karthik4u
Messages: 36
Registered: September 2006
Location: CHENNAI

Member

Hi All,

Whether we need to restart DB after Table Partition?

Thanks

Report message to a moderator

Re: DB Restart after Table Partition [message #636379 is a reply to message #636376]

Wed, 22 April 2015 09:03

BlackSwan
Messages: 26766
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/

Report message to a moderator

Re: DB Restart after Table Partition [message #636380 is a reply to message #636376]

Wed, 22 April 2015 09:04

Lalit Kumar B
Messages: 3174
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

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

Report message to a moderator

Re: DB Restart after Table Partition [message #636383 is a reply to message #636382]

Wed, 22 April 2015 09:09

karthik4u
Messages: 36
Registered: September 2006
Location: CHENNAI

Member

But guys around me confused me as usual Wink

Report message to a moderator

Re: DB Restart after Table Partition [message #636384 is a reply to message #636383]

Wed, 22 April 2015 09:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

karthik4u wrote on Wed, 22 April 2015 07:09

But guys around me confused me as usual

what prevents you from conducting actual test to just see what happens yourself?????????????////

Report message to a moderator

Re: DB Restart after Table Partition [message #636386 is a reply to message #636383]

Wed, 22 April 2015 09:13

Lalit Kumar B
Messages: 3174
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).

Report message to a moderator

Re: DB Restart after Table Partition [message #636388 is a reply to message #636386]

Wed, 22 April 2015 09:26

EdStevens
Messages: 1376
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

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Thanks Ed.

Report message to a moderator

Re: DB Restart after Table Partition [message #636390 is a reply to message #636388]

Wed, 22 April 2015 09:35

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Ed, your link is slightly off. OP should probably use this one.

Report message to a moderator

Re: DB Restart after Table Partition [message #636400 is a reply to message #636390]

Wed, 22 April 2015 14:17

EdStevens
Messages: 1376
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.

Report message to a moderator

Re: DB Restart after Table Partition [message #636401 is a reply to message #636400]

Wed, 22 April 2015 14:54

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

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.

Report message to a moderator

Re: DB Restart after Table Partition [message #636407 is a reply to message #636400]

Thu, 23 April 2015 00:08

Lalit Kumar B
Messages: 3174
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 17 22:23:21 CST 2025