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
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
What is the default fill factor value? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
Can you redefine a table online?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
how can you find out if a table can be redefined?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Explain about your sql server dba experience? : sql server 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 can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What is dcl? : sql server DBA
how can you process messages in order asynchronously?
What is the difference between clustered and non-clustered index? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA