11-17-2015
Find User who dropped table in teradata DB
HI Team
Is there a way to track which user dropped the table in Teradata ?
Please share the query or approach .
Thanks
7 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
in a xen environment , i see a lot op dropped packets via netstat -i
Is this a sign of network problems, or is it normal to see this kind of numbers? i'm not sure how to interprete the data. is this normal, bad, critical. What are your stats on this?
I guess i have a xen issue of some sort,... (1 Reply)
Discussion started by: progressdll
1 Replies
2. SuSE
I have deleted a database. I restored it again with a backup.
Now we lost some data of two days.
Is it possible to restore this lost data? (5 Replies)
Discussion started by: Eastme
5 Replies
3. Shell Programming and Scripting
Hello guys,
what i want to do is to print a table with two columns (user :: #procs) on the stdout.
The first column should show the users and the second one the number of processes the respective user runs.
I think I need something like the count() - function in sql, don't i?
Shell: Bash
... (2 Replies)
Discussion started by: tiptop
2 Replies
4. Ubuntu
This is the mistake that i've done :
First of all go to /etc/apt/sources.list folder from terminal or using file manager ...
than copy the content of sources.list in to your adequate source.list.
Create a file named sources.list.bt and paste the same content
In the end open the... (0 Replies)
Discussion started by: dud3
0 Replies
5. Shell Programming and Scripting
Dear All,
I have table files with different measurements for the same sensors. The first column indicate the sensor (7 different sensors and 16 measurements in the example below). I would like to find the best measurement for each sensor. The best measurement is determined by the higher value of... (10 Replies)
Discussion started by: GDC
10 Replies
6. News, Links, Events and Announcements
Fedora and openSUSE will replace MySQL with MariaDB:
Oracle who? Fedora & openSUSE will replace MySQL with MariaDB | ZDNet
The article also has a comment that Chakra is planning on doing the same. No doubt the Fedora based distributions are planning to do the same. (7 Replies)
Discussion started by: figaro
7 Replies
7. Shell Programming and Scripting
Hi All,
As per my biz requirement, I need to drop the partition from our PROD table based on the retention period.
Hence I have written the script and called the drop partition procedure within the script.
The procedure is working fine and droped the partition from the table when I execute... (4 Replies)
Discussion started by: suresh_target
4 Replies
CDPLAY(1) General Commands Manual CDPLAY(1)
NAME
cdplay - play audio compact disks
SYNOPSIS
cdplay [ -a]|[-r]
DESCRIPTION
Cdplay is an audio-cdplayer it can be used interactively or non-interactively. With no flags cdplay is used interactively. When used inter-
actively cdplay can be either in non-playing or playing mode. In non-playing mode you can select tracks to be played. In playing mode
cdplay shows the track-time, remaining track-time, total-time and remaining total-time. Cdplay assumes the drive to be at /dev/cd0.
During non-playing mode the following commands are available:
cursor-up/down
browse through the track-list
spacebar
add track to the play-list
backspace
remove a track from the play-list
s start playing the tracks in the play-list. When the play-list is empty start playing from the current position in the track-list
until the end of the cd
p play the track on the current position in the track-list
r play all tracks in a random order (shuffle play)
e exit cdplay
During playing mode the following commands are available:
s stop playing, return to non-playing mode
spacebar
pause/resume current track
cursor-up/down
skip to next/previous track
OPTIONS
When one of these options is used cdplay does everything in the background.
-a Play all tracks, cdplay tells the drive to play all tracks and then it immediately returns to the user
-r Play all tracks in random order (shuffle play). Cdplay forks of a new process which starts up a track, during that track it sleeps.
When the track is finished it wakes up to start the next track and goes to sleep again. The parent process immediately returns to
the user.
BUGS
Cdplay does not sense if a cd has changed, so don't switch cd's. If you want to play another cd you have to insert the new cd and start
cdplay again.
AUTHOR
Michel R. Prevenier (mrpreve@cs.vu.nl)
CDPLAY(1)