where we can find block corruption? which view desc block corruption?
Latest Answer: using Rman we can find it.V$block_corruption view there to find out corrupted blocks.Rman>block recover datafile block ;using above statement we recover corrupted blocks. ...
Latest Answer: mutation of triggers is an example of deadlock.......for flashback we can use to being tables from recyclebin ...
Latest Answer: yes you can use it ...but need to enable the index ...
Very next day on the prodction box It looks some procedres/packages got invlidated. What command I should give to know how many packges are invalidated. If suppose thousands are the packages invalidated then what command I should Issut to get then validated.
See, If the export dump is in one characterset and the target database which has to be imported is in another characterset how could we import that particular dumpfile into target database ?
Need to create a short tax book from Nov-Jan.Corp book runs from Feb-Jan and Tax book from Nov-Oct.Only some retired Assets must be copied on the new tax book.what steps need to be necessiated...?
The DBA has added STATE column to the CUSTOMERS table and has asked you to add acorresponding State item to the Customers block of the Orders form. You want to make it easier for order entry clerks to enter the correct state abbreviation. Most customers are located in five southeastern states, although on very rare occasions there will be customers from outside that area. You decide to implement a list item with five values for the State item and allow clerks to enter the state abbreviation director
Latest Answer: Database Modelling is - Logical and Physical Modelling. Logical Modelling is independent of Type of Database.. Once Logical Database Model is built. You can create Phsical Model depending on type of database. Database Design - It is ...
Dual table explain. Is any data internally storing in dual table. Lot of users are accessing select sysdate from dual and they getting some millisecond differences. If we execute SELECT SYSDATE FROM EMP; what error will we get. Why
Latest Answer: You can create a procedure to return REF cursor or VARRAY or PL/SQL Table type out parameters which can return more than one value. ...
View page [1] 2 3 Next >>
Go Top
