What is a Private Synonyms ?
Answer / orawhiz
A Private Synonyms can be accessed only by the owner.
| Is This Answer Correct ? | 1 Yes | 0 No |
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
material view and view disadvantages?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
How to turn on or off recycle bin for the instance?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is an Index Segment ?
Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.
How to define a cusotmer as a supplier in ORACLE R12
Can objects of the same schema reside in different tablespace?
12. Display the client name in upper case only and in lower case only.
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?