Hi UK
Again, what is the purpose of UNDO_RETENTION ? I can understand that it retains the information for that period, generally for the purpose of flash-back queries.
But suppose I have specified UNDO_RETENTION = 10800 , i.e 3 hrs.
I issues a last DML at 05.00 pm . Now when I see at 09.00 pm...
Hi there ,
I have Oracle 9i database. In its init.ora file following parameters are defined
UNDO_MANAGEMENT = AUTO
UNDO_RETENTION = 10800
UNDO_TABLESPACE = UNDOTBS1
The size of my undo tablespace has grown to 7GB.
I have few queries with undo tablespace.
1. How has undo tablespace grown ...
Shall it be done only through TRANSPARENT GATEWAYS !!
In Oracle Hetrogenous Services there is also Oracle Generic Connectivity. Can't we make use of it ?
In fact I tried to go thourgh the Oracle Hetrogenous Services but not able to understand the setting up of Agents and Class information. It...
Hello Friends,
I wish to access clipper applicaton's (.dbf) files from Oracle. I have learnt that it can be done with ODBC but dont know how to proceed with it.
Can any one help me out . Its urgent
In fact I my further plan is to create a view using the Oracle tables and the dbf files
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.