 table redefinition [message #323710] |
Thu, 29 May 2008 05:25  |
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 #323720 is a reply to message #323710] |
Thu, 29 May 2008 05:48  |
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 |
 |
Michel Cadot
Messages: 68727
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 #323740 is a reply to message #323734] |
Thu, 29 May 2008 06:15 |
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 #323749 is a reply to message #323710] |
Thu, 29 May 2008 06:28 |
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 #323759 is a reply to message #323710] |
Thu, 29 May 2008 06:40 |
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 #323768 is a reply to message #323759] |
Thu, 29 May 2008 07:16 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
