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
I have some query regarding Report generation from Oracle
Apps "PO module".
I have to generate a report where table columns are as below:
Vendor_name Invoice No PO Number Item_Quantity Value of
Goods Date of Shipping Name_of_the_transport
Now my questions is :from which table/column I can get the
information of "Name_of_the_transport" column.
Thanks in advance.
How many segment are present in Oracle Manufacturing
Which environment variables are absolutely critical in order
to run the OUI?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column
in DATA_EXTRACT_VIEWS table contain NULL value?
for what purpose we use MDM(master data management)tell me plz.
what is port in oracle? how is it related to database
What is Reduced List of Values?
what are the types of LIST REPORTS in cognos8BI? and
what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
You have 4 instances running on the same UNIX box. How can
you determine which shared memory and semaphores are
associated with which instance?
what is normalization?
types of normalization?
example of each form?
how do u implement normalization in ur project?
from where do u receive the information to develop report
Hey i want to join oracle apps so will you pls tell me that
which institute is best in hyderabad.
A table t is there.If you perform insert
,update and delete then the trigger will fire.What is
the minimum no of trigger required for a table.
did u p prepared complex report
does the query needs a hint to access a materialized view?