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?
Hi how to import oracle sequence in Informatica? Please
write stored procedure code that will import oracle sequence
in Informatica SP transformation as per below scenario
Oracle table product list
Pro_id, pro_name, price
101, LED Lights,200
102, 20 watt CFL Lights, 145
103, 30 watt CFL lights,155
Now a new flat file with new product list needs to be added
to oracle table product list with oracle sequence
flat file product list has two column
20 watt tube light ,45
30 watt tube light ,60
dear all,Greetings of the day..
i have a small query plz rply if u knw..
i have done MBA Hr and B.sc microbiology.
i am very much interested in it industry,so i am planing to
go with oracle HRMS module,can it be work out??
how you will identify the mapping level bottleneck ? if
there is a mapping level bottleneck then how will you try
to improve the mapping
i have all the Oracle Certification material from 1z0-001
to 1Z0-643, if required just drop me a mail to:
What is built_in Subprogram ?
What is a Built_in subprogram ?
please provide what question will be asked in CWE in bank it
hello to all i want code for like this site "Submit
Question" page.please give answers thanks.
Explain the Normalized Relations?
i have table as source table and flat file as target
i need yo perform some logic in loading the data.
is it posible?
and one more thing the no of fields in source is 200+
and for target is 30+
how i can map them.........
what are parameter, we can check after creating a database in
terms of QC and for each tables what should be the parameters
for QC and QA?
Single File Database: Develop a student record management
which uses single file as its database. It is not supposed
additional files at any part of the project and should never
total content. It must be capable of storing 100000's of
should support variable length records to be added, deleted,
Which parameters are optional in init.ora parameter file?
what is the index and synonym. i have the definitions ...can
any one give me brief explanation..
How can we check whether A S M instance is up or down?
How can we tune a oracle database if log file sync issue comes