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?
hello friends Im doing my final year engineering in B.Tech..
one of uncle said he can provide job in his company if im
good in database management. but i have only basic knowledge
about database, so like to join database management course
in good intuition. so friends kindly help me to get good
intuition because its my future.
create or replace procedure show_tab_rec ( P_tab VARCHAR2 )
cmd := 'select *
from '|| P_tab;
for int in ( execute immediate cmd )
dbms_output.put_line ( int.ename||' '||int.deptno);
when i m compling this procedure i m getting this error
PLS-00103: Encountered the symbol "IMMEDIATE" when expecting
of the following:
. ( ) , * @ % & | = - + < / > at in is mod remainder not
range rem => .. <> or != or ~= >= <= <>
and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member
PLZ solve this error
give this question answer asap
Please send me technical questions related to
What are the package used in DBMS ?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS
INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS
FROMORG TOORG FROMINV TOINV ..
How to create Drill down report?
How to move the data from one flatfile to multiple staging
tables?give me some examples?
for example in po interface one flat file is there and
multiple staging tables are there how can move it?please
give me answer for this question?
What are the ways tablespaces can be managed and how do they
What is the difference between BPA AND Contract
What are documents and test cases u followed
what are all the conversion and interfaces in GL,AP,AR,HRMS
otherwise send send link for these
did u received a single file or multiple files
My requirement is like in database some defects are present
and i need to clean them.To be brief for example every
employee should have active assigments.So for those records
which are not having status as active or null ,i need to
update the roecords using API with the correct value.
Client will provide a flat file for the records whch are
defected.So i need to run the API for those records (flat
file)and update the data in database.
So my question is how to handle this requirement.Is there
any existing API for this purpose?If yes then please send
me the NAME.
How to update the records in the database using flatfile.
Any pointer will be appreciated.Thanks in advance.
can u plz provide me oca sql dumps please i need them
I have 2 tables with 1 million rows each.
I have updated 1 row in first and 1 million update on second table.
Now I commit both the updates. Which one will commit fast and Why?
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 view(s) do you use to associate a users SQLPLUS session
with his o/s process?