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
hello to all i want code for like this site "Submit
Question" page.please give answers thanks.
what is difference between
1.append to media
2.overright the existing media
when we take back up in sql server2000
Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?
Suppose database is running slow, what will you do?
Explain the Normalized Relations?
What are the package used in DBMS ?
how to restore particular schema from rman full backup?
what is normalization?
types of normalization?
example of each form?
how do u implement normalization in ur project?
what is the difference between filters and conditions?
when All datafiles related to a Tablespace are removed ?
What is built_in Subprogram ?
what is the index and synonym. i have the definitions ...can
any one give me brief explanation..
1)How to check tablespace utilization?
2)what are the RMAN CLONING STEPS?
3)what is standby database?
4)what is difference between standalone database and target
5)How to backup the standalone database?
6)tell about the ubgrade steps?
7)How to apply the pathes?
what is scan listener.
With DTS packaging I can store tables in Excel and convert
them back to SQL. But once I copied tables to Excel I want
to modify some info. How you do that without editing the