:: Home     :: Add Questions
Register   |   Login
 

Question :: A developer is trying to create a view and the database won?t let him. He has the "DEVELOPER" role which has the "CREATE VIEW" system privilege and SELECT grants on the tables he is using, what is the problem?

Post Answer

Tags

Answers to ""

 

The best way is to analyze the table and then use the data provided in the DBA_TABLES view to get the average row length and other pertinent data for the calculation. The quick and dirty way is to look at the number of blocks the table is actually using and ratio the number of rows in the table to its number of blocks against the number of expected rows.

Related Questions

::Top Tags::
 
 
Copyright 2007, Megasolutions Ltd