Sponsored Content
Full Discussion: SQL admin tool
Special Forums UNIX and Linux Applications SQL admin tool Post 302530972 by DGPickett on Wednesday 15th of June 2011 01:06:44 PM
Old 06-15-2011
Usually, you write that stuff, usually specific to the RDBMS.
  • With triggers and signalling, you can divert or mark and hide from a view unapproved rows, send notification, queue for approval, move/unmark on approval. Hide from view ensures that it already conforms to constraints, but divert to queue table is more secure.
  • With triggers and individual logins, you can log all table changes against the user. If you design the app as mainly insert-only, you have 100% history and other advantages.

Last edited by DGPickett; 06-15-2011 at 02:34 PM..
 

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

linux command line admin tool

Dear All, I am new to linux administration. what is the tool that is used to admin the linux server from remote client using telnet session. It can be used on the server also but start from command line with out Xwindows. just like SMIT in AIX. With Regards, Varma. (1 Reply)
Discussion started by: jarkvarma
1 Replies

2. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Hi- I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment... I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
5 Replies

3. Shell Programming and Scripting

Execute multiple SQL scripts from single SQL Plus connection

Hi! I would like to do a single connection to sqlplus and execute some querys. Actually I do for every query one connection to database i.e echo 'select STATUS from v$instance; exit' > $SQL_FILE sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
6 Replies

4. UNIX for Advanced & Expert Users

Call parallel sql scripts from shell and return status when both sql are done

Hi Experts: I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
Discussion started by: huasheng8
3 Replies

5. What is on Your Mind?

Windows Admin switching to *nix Admin

I'm currently a Windows admin and have wanted to jump ship to the *nix side for a while now. I've been studying both through an lpic level 1 manual as I have time (focusing on debian), and a solaris 10 cert book. The problem is I only have a handful of hours a week to study, and my current job... (3 Replies)
Discussion started by: bobwilson
3 Replies

6. What is on Your Mind?

Regarding Admin life either as DBA or UNIX Linux admin

I am planning to choose my career as Unix/Linux Admin or a DBA. But I have come to know from forums and few admins like the job will be 24/7. I have few questions on that. Can we get "DAY" shifts in any one of the admin Job ? Can't we have shift timings in any company ? Eventhough the... (7 Replies)
Discussion started by: Jacktts
7 Replies

7. Shell Programming and Scripting

Storing multiple sql queries output into variable by running sql command only once

Hi All, I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise. Eg : Select 'Query 1 output' from dual; Select 'Query 2 output' from dual; I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
dupdp-admin(1)						      General Commands Manual						    dupdp-admin(1)

NAME
dupdb-admin - Manage the duplicate database for apport-retrace. SYNOPSIS
dupdb-admin -f dbpath status dupdb-admin -f dbpath dump dupdb-admin -f dbpath changeid oldid newid DESCRIPTION
apport-retrace(1) has the capability of checking for duplicate bugs (amonst other things). It uses an SQLite database for keeping track of master bugs. dupdb-admin is a small tool to manage that database. The central concept in that database is a "crash signature", a string that uniquely identifies a particular crash. It is built from the executable path name, the signal number or exception name, and the topmost functions of the stack trace. The database maps crash signatures to the 'master' crash id and thus can close duplicate crash reports with a reference to that master ID. It also tracks the status of crashes (open/fixed in a particular version) to be able to identify regressions. MODES
status Print general status of the duplicate db. For now, it only shows the time when the database was "consolidated" last, i. e. when the bug states (open/fixed) in the SQLite database where updated to the actual states in the bug tracking system. dump Print a list of all database entries. changeid Change the associated crash ID for a particular crash. OPTIONS
-f path, --database-file=path Instead of processing the new crash reports in /var/crash/, report a particular report in an arbitrary file location. This is use- ful for copying a crash report to a machine with internet connection and reporting it from there. This defaults to ~./apport_dupli- cates.db. AUTHOR
apport and the accompanying tools are developed by Martin Pitt <martin.pitt@ubuntu.com>. Martin Pitt August 01, 2007 dupdp-admin(1)
All times are GMT -4. The time now is 03:37 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy