Track changes to Oracle table

8 More Discussions You Might Find Interesting

1. Programming

DB2 z/os How to Track table delete Activities

Dear Team I am using DB2 v10 z/os database . Need expert guidance to figure out best way to track table activities ( Ex Delete, Insert,Update ) Scenario We have a table which is critical and many developer/testing team access on daily basis . We had instance where some deleted entire table ....

2. Programming

How to track table status delete/update/insert status in DB2 V10 z/os?

3. UNIX and Linux Applications

Help in copying table structure to another table with constraints in Oracle

hi, i need to copy one table with data into another table, right now am using create table table1 as select * from table2 i want the constraints of table1 to be copied to table2 also , can anyone give me some solution to copy the constraints also, now am using oracle 10.2.0.3.0...

4. Shell Programming and Scripting

Check the record count in table (table in oracle)

I have requirement: 1) Check the record count in table (table in oracle) 2) If records exists generate the file for existing records and wait for some time then Go to sleep mode and Again check the record count after 10 min.......... (Loop this process if record count >0). 3) Generate touch...

5. Shell Programming and Scripting

Check the record count in table (table in oracle)

I have requirement: 1) Check the record count in table (table in oracle) 2) If records exists generate the file for existing records and wait for some time (Go to sleep mode) and Again check the record count after 10 min.......... (Loop this process if record count >0). 3) Generate touch...

6. UNIX for Dummies Questions & Answers

Possible to track FTP user last login? Last and Finger don't track them.

Like the topic says, does anyone know if it is possible to check to see when an FTP only user has logged in? Because the shell is /bin/false and they are only using FTP to access the system doing a "finger" or "last" it says they have never logged in. Is there a way to see when ftp users log in...

7. HP-UX

upload oracle table

am on HP-Unix and want to upload table on windows oracle from HP-Unix Thanx Swapnil

8. UNIX for Dummies Questions & Answers

Unix Oracle Track

I was wondering if anybody thinks that going through a tech school for Unix--Oracle based classes is worth paying 6 to 10 grand on it..I really want to learn Unix, so I bought a book on it, but I really want to impliment what Iam learning from the book, is the class route a better way or are there...

LEARN ABOUT REDHAT

drop_trigger

DROP 
TRIGGER(7) 						   SQL Commands 						   DROP TRIGGER(7)

NAME

       DROP TRIGGER - remove a trigger

SYNOPSIS

       DROP TRIGGER name ON table [ CASCADE | RESTRICT ]

   INPUTS
       name   The name of an existing trigger.

       table  The name (optionally schema-qualified) of a table.

       CASCADE
	      Automatically drop objects that depend on the trigger.

       RESTRICT
	      Refuse to drop the trigger if there are any dependent objects.  This is the default.

   OUTPUTS
       DROP TRIGGER
	      The message returned if the trigger is successfully dropped.

       ERROR: DropTrigger: there is no trigger name on relation "table"
	      This message occurs if the trigger specified does not exist.

DESCRIPTION

       DROP  TRIGGER will remove an existing trigger definition. To execute this command the current user must be the owner of the table for which
       the trigger is defined.

EXAMPLES

       Destroy the if_dist_exists trigger on table films:

       DROP TRIGGER if_dist_exists ON films;

COMPATIBILITY

       SQL92  There is no DROP TRIGGER statement in SQL92.

       SQL99  The DROP TRIGGER statement in PostgreSQL is incompatible with SQL99. In SQL99, trigger names are not local to tables, so the command
	      is simply DROP TRIGGER name.

SEE ALSO

       CREATE TRIGGER [create_trigger(7)]

SQL - Language Statements					    2002-11-22							   DROP TRIGGER(7)

Shell Programming and Scripting