on 12-30-2011 5:35 AM
Hi,
how can i see the detail of DDL command executed on oracle 10g on ECC 6.0
ECC 6.0
HPUX
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>> how can i see the detail of DDL command executed on oracle 10g on ECC 6.0
select dbms_metadata.get_ddl('<OBJECTTYPE>','<TABLENAME>','<OWNER>') from dual;
Best regards,
Orkun Gedik
want to display all or user wise DDL commands.
>> want to display all or user wise DDL commands.
SQL> set long 5000
SQL> select dbms_metadata.get_ddl('<OBJECTTYPE>','<TABLENAME>','<OWNER>') from dual;
if i reset the password via alter command.
then how can i see ???
Did you activated the auditing mechanish on the Oracle? If it is active, you can query the audit table;
select * from sys.aud$;
Another way is using Oracle Log Miner. You can find the related information, on the link below;
http://docs.oracle.com/cd/B10501_01/server.920/a96521/logminer.htm
thanks to all
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.