You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week old and partial backup of this datafile which is just 1 day old. From which backup should you restore this file?
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
How do you increase the OS limitation for open files (LINUX
How can we expand Parameter Form Canvas on Reports 6i?
Is there any link between pr form(purchse requisition)and po
What is the Difference between the Person_Type_id column in
the per_all_people_f and per_person_type_usages_f
How would you go about verifying the network name that the
local_listener is currently using?
Which dictionary tables and/or views would you look at to
diagnose a locking issue?
what are bitmap indexes? How does they work?
Define the SGA and: How you would configure SGA for a
mid-sized OLTP environment? What is involved in tuning the SGA?
What is the meaning of "Modulus" and "Alignment" in a
datafile. Data file might be from any database. Data file is
created through unloading data from a table. So, while
loading this data into my table, I need to use these keywords.
Could any one can help me regarding this?
how do u setup a replication site?
what is the use of triggers in Java program? I mean where do
we use triggers in Java programming?
Could you please let me know the interfaces in OM / FA??
Database is hung. Old and new user connections alike hang on
impact. What do you do? Your SYS SQLPLUS session IS able to