Oracle Tables [message #470750] |
Tue, 10 August 2010 11:09 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
muktha_22
Messages: 527 Registered: December 2009
|
Senior Member |
|
|
Hello,
It is very grateful if u clear my below doubts on table.
Question 1:
What is the no of column limits in a single table? Is it same for all type of tables.
Question 2:
How to estimate the size for a table in advance with "undo generation amount, index size, redo log size"?
Question 3:
What is the real time scenario for creating a table on another schema?
Question 4:
I read the below line in a document, but I'm not able to understand it
"we can't move types and extent tables to a different schema when the original data still exists in the database"?
Thanks in advance
|
|
|
Re: Oracle Tables [message #470753 is a reply to message #470750] |
Tue, 10 August 2010 11:14 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Still waiting for a feedback from you on your previous topic.
Michel Cadot wrote on Sun, 08 August 2010 16:171/ See above
2/ See above
3/ Too bad for you
4/ No
5/ Database Reference contains the list of all parameters, try to find the appropriate one by yourself and come back with the answer.
A feedback is appreciated BEFORE you post the next topic above all if the next topic is the same as the previous one.
And in this case, DO NOT create a new topic continue on the same one.
Regards
Michel
[Updated on: Tue, 10 August 2010 11:15] Report message to a moderator
|
|
|
Re: Oracle Tables [message #470814 is a reply to message #470753] |
Tue, 10 August 2010 23:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
muktha_22
Messages: 527 Registered: December 2009
|
Senior Member |
|
|
Hello Michel,
Sorry for delay feedback,
Thank u so much for your prompt help.
But still i'm not able to get the control trace file on the folder 'oracle\admin\UDUMP', when I create a control file to trace.
Can you tell me the default location if that is not the one.
Thank you so much...
|
|
|
|
|
|
Re: Oracle Tables [message #471052 is a reply to message #471013] |
Thu, 12 August 2010 01:59 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
1/ Database Reference (already gave it to you in your previous topic) see annexes.
2/ Estimation of table size is estimation of each field, taking account pctfree you will use, number of rows you will have. Same thing for index size. Other estimations depend on the statements, how many times you will execute and from how many users.
3/ Many but rare
4/ Where? Post link.
Regards
Michel
|
|
|