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?
1) WIll all the user get the DEFAULT profile, if their
current profile got deleted at any point of time?
2) What are the Situation we need to MOVE the TABLE between
3) What is the use of MOVING the TABLE between SCHEMA'S?
4) What are the Table Clause, Segment Clause and the
Datafile Clause which will override each other?
5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is the difference between BPA AND Contract
What are documents and test cases u followed
1.In a table Gender is a column in that male and female are
the two data.In a single statement i have to modify all male
to female and all female to male vice versa.
2.In a single query i need the count of male data,count of
female and total count
How can I convert single byte kana characters into multi
byte kana characters and vice-versa.
What is the difference between Memory_target and
Memory_max_target? Why its required to resize these parameter?
can u send the sql dumps to firstname.lastname@example.org
plz help me
What is Tax Categories?
1. What is PO rate variance gain and loss?
What are the Features of Forms 6i over 4.5?
What are the Features of Forms 10g?
What are the Features of Reports 6i?
What are the Features of Reports 10g ?
what is difference between group above and group left report
i want to print the employee details on department wise with
group above report with the fields
I WANT OUTPUT LIKE THIS
1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE
AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE
WHAT I HAVE TO DO
ENAME SAL COMM
A 2000 2222
ENAME SAL COMM
MILLER 220 22
D 45 23
LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE
EXISITING IN EMP TABLE
when we are importing items in inventory, showing errors,
Oracle support suggested us for running scripts & also
suggested if we run scripts, iprocurement applicaation if is
there it will show shared and if we go in future for
iprocurement, it wont work. So kinldy suggest any functional
Database crashes. Corruption is found scattered among the
file system neither of your doing nor of Oracles. What
database recovery options are available? Database is in
archive log mode.
Why does Oracle not permit the use of PCTUSED with indexes?