Interested to Buy Any Domain ? << Click Here >> for more details...
hi,
suppose i created one table after few days i did some
insert,update how can i know when will i did ddl or dml
operation is undergone on that table
- 3 Answers
- 7241 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / prashe
select OWNER,OBJECT_NAME,CREATED,LAST_DDL_TIME,from
dba_objects where OBJECT_NAME='&object_name';
for DDL command.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
how does an oracle clusterware manage crs resources?
Where do you find the default index fill factor and how to change it? : sql server DBA
how to restore files with rman?
Explain about your sql server dba experience? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
what is the diffrence between core dba and apps dba?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
How to start SQL Server in minimal configuration mode?
What is dbcc? : sql server DBA
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 the default port no on which sql server listens? : sql server DBA
when does an alert gets signaled?
