Home » SQL & PL/SQL » SQL & PL/SQL » table redefinition (oracle 10g)
icon7.gif  table redefinition [message #323710] Thu, 29 May 2008 05:25 Go to next message
rajanisis
Messages: 5
Registered: May 2008
Junior Member
Is there any documentation to show how Oracle table redifinition works at the OS level


regards

Rajanikant Kumar
Re: table redefinition [message #323713 is a reply to message #323710] Thu, 29 May 2008 05:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nothing is done at OS level.

Regards
Michel
Re: table redefinition [message #323720 is a reply to message #323710] Thu, 29 May 2008 05:48 Go to previous messageGo to next message
rajanisis
Messages: 5
Registered: May 2008
Junior Member
if we copy the data of intrim table to main table then at that time ,is main table is lock ,if lock then the corrosponding dependent object is invalid or valid just explain
Re: table redefinition [message #323722 is a reply to message #323720] Thu, 29 May 2008 05:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ This is NOT Oracle table redefinition
2/
Quote:
,is main table is lock ,

There is a share lock on table and an exclusive lock on inserted rows.
3/
Quote:
if lock then the corrosponding dependent object is invalid or valid

Valid (but I'm not sure you mean this in Oracle sense).

Regards
Michel

[Edit: add missing NOT in 1/]

[Updated on: Thu, 29 May 2008 06:07]

Report message to a moderator

Re: table redefinition [message #323730 is a reply to message #323722] Thu, 29 May 2008 06:01 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
There's a fairly detailed walkthrough here
Re: table redefinition [message #323734 is a reply to message #323730] Thu, 29 May 2008 06:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I didn't post the link as I was not sure OP is talking about this.
Actually I don't know what OP has in mind.

Regards
Michel
Re: table redefinition [message #323740 is a reply to message #323734] Thu, 29 May 2008 06:15 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Me neither, other than it's probably to do with Dbms_Redefinition. If all else fails, throw the docs at them and just walk away.
Re: table redefinition [message #323742 is a reply to message #323710] Thu, 29 May 2008 06:19 Go to previous messageGo to next message
rajanisis
Messages: 5
Registered: May 2008
Junior Member
In which step of table redefinition the dependent object of table is invalid .please explain in details.


Regards
Rajanikant
Re: table redefinition [message #323745 is a reply to message #323742] Thu, 29 May 2008 06:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What table redefinition means for you?
What invalid means for you?
Explain in details.

Regards
Michel
Re: table redefinition [message #323749 is a reply to message #323710] Thu, 29 May 2008 06:28 Go to previous messageGo to next message
rajanisis
Messages: 5
Registered: May 2008
Junior Member
In which step of on line table redefinition, the object which depends on table(which is on line redefind) is get invalid(means need to recompile) in oracle.


regards
Rajanikant
Re: table redefinition [message #323751 is a reply to message #323749] Thu, 29 May 2008 06:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Thu, 29 May 2008 13:20
What table redefinition means for you?
What invalid means for you?
Explain in details.

Regards
Michel


Re: table redefinition [message #323759 is a reply to message #323710] Thu, 29 May 2008 06:40 Go to previous messageGo to next message
rajanisis
Messages: 5
Registered: May 2008
Junior Member
i am using DBMS_REDEFINITION package for Redefining Tables Online .In which there is number of step which i have to folow
Now my question is that in which step of Online Redefining Tables the dependent object like trigger,views,constraint etc will invalid.
Now please explain in details


Regards
Rajanikant
Re: table redefinition [message #323763 is a reply to message #323759] Thu, 29 May 2008 06:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't owe you anything so now read the doc.

Regards
Michel

[Updated on: Thu, 29 May 2008 06:51]

Report message to a moderator

Re: table redefinition [message #323768 is a reply to message #323759] Thu, 29 May 2008 07:16 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Up until this point, I knew nothing about Dbms_Redefinition.

It took me about 5 minutes to read the first couple of pages of the docs here

As far as I can tell, the triggers and constraints on the table are never invalid - they are transferred over valid.

I don't know how views are treated. I would guess that they would be treated like cursors and procedures, and be invalidated in the final step of Redefinition.

Now - why couldn't you find this out for yourself - you'd be much more likely to remember it if you had done, and you'd have picked up other information about Dbms_Redefiniton along the way, just like I have.
Previous Topic: To do in a single query
Next Topic: Procedure created by PL/SQL won't compile
Goto Forum:
  


Current Time: Fri Dec 09 00:22:21 CST 2016

Total time taken to generate the page: 0.12111 seconds