You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?
No Answer is Posted For this Question
Be the First to Post Answer
Give one method for transferring a table from one schema to another?
How do I become a dba?
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?
You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
What is your favorite tool for day-to-day oracle operation?
Why are recursive relationships bad? How do you resolve them?
What is the easiest method to create a file on unix?
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.
Tell me about standby database? What should we watch out for?
When configuring sqlnet on the client what files need to be set up?
The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?