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?
No Answer is Posted For this Question
Be the First to Post Answer
What is the finger command?
Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
Give one method for transferring a table from one schema to another?
What are the beneficial tools for administering the database?
How does one create a new database?
When configuring sqlnet on the client what files need to be set up?
A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.
What are bind variables and why are they important?
Explain the wait events in statspack report 'enqueue'?
What is the difference between a database and instance?
What is dba and functionalities of dba?
Explain force logging feature in 9i.