Sponsored Content
Top Forums UNIX for Dummies Questions & Answers finding out tables not used in scripts. Post 100823 by silver123 on Thursday 2nd of March 2006 06:18:46 AM
Old 03-02-2006
finding out tables not used in scripts.

I need to findout the list of tables that are not being used in scripts.

Towards that, I need to do the following activities:

1) I have all the table names in a file called tables.txt

2) Take each table name from tables.txt and Check if it is present in any of the scripts in kshscripts directory (which has all ksh scripts and which uses the tables) using grep command.

3) The script has to loop through the contents of tables.txt one by one and take each table name and find it's presence in /kshscripts directory

4) We need to get the list of tables that is not present in any of the scripts.

I don't have much experiance in shell script, Please let me know how i can accomodate the above requirement.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

use shell scripts to update tables from databases

Hi I need to write a shell script that will access tables available on webpages and update a table on my webpage on a periodic basis. It will access, say for example a website that periodically update a table with certain quantities and update my table accordingly.it should have the flexibility... (0 Replies)
Discussion started by: wannabegeek
0 Replies

2. Shell Programming and Scripting

finding duplicate files by size and finding pattern matching and its count

Hi, I have a challenging task,in which i have to find the duplicate files by its name and size,then i need to take anyone of the file.Then i need to open the file and find for more than one pattern and count of that pattern. Note:These are the samples of two files,but i can have more... (2 Replies)
Discussion started by: jerome Sukumar
2 Replies

3. Shell Programming and Scripting

Converting tables of row data into columns of tables

I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated. Input: test_data_1 1 2 90% 4 3 91% 5 4 90% 6 5 90% 9 6 90% test_data_2 3 5 92% 5 4 92% 7 3 93% 9 2 92% 1 1 92% ... Output:... (7 Replies)
Discussion started by: justthisguy
7 Replies

4. Shell Programming and Scripting

Finding tables from each script

Hi, I just want to take each sql script from specified directory and print all tables in those sqls. Below is the script but getting an error lik ksh: 0403-057 Syntax error: `(' is not expected. Script is---- ls /ukdw/prd/working/TDMatrix/srualcb02/ukdw/prd/bin | awk '{printf("%s... (2 Replies)
Discussion started by: subrat
2 Replies

5. Shell Programming and Scripting

tables in scripts

Hi , I have two tables with same length t1 and t2, I want to cretae a new third table where i put the difference between the elements of t2 and t1, t3= t1 - t2 t3= t1 - t2 I am new to scripts, any help please? thanks (7 Replies)
Discussion started by: Celine19
7 Replies

6. Shell Programming and Scripting

Changing the Bash Scripts to Bourne Scripts:URGENT

Hi, I have to write a program to compute the checksums of files ./script.sh I wrote the program using bash and it took me forever since I am a beginner but it works very well. I'm getting so close to the deadline and I realised today that actually I have to use normal Bourne shell... (3 Replies)
Discussion started by: pgarg1989
3 Replies

7. Shell Programming and Scripting

KSH - How to call different scripts from master scripts based on a column in an Oracle table

Dear Members, I have a table REQUESTS in Oracle which has an attribute REQUEST_ACTION. The entries in REQUEST_ACTION are like, ME, MD, ND, NE etc. I would like to create a script which will will call other scripts based on the request action. Can we directly read from the REQUEST_ACTION... (2 Replies)
Discussion started by: Yoodit
2 Replies

8. Shell Programming and Scripting

[Solved] Finding a word in all shell scripts

Hi i have to find the shell script that contain the word PROC__TO_UPDATE SEARCH SHOULD BE INSENSITIVE AND SCRIPT CAN BE DEPLOYED IN ANY PATH. I am on Solaris. (27 Replies)
Discussion started by: rafa_fed2
27 Replies

9. Shell Programming and Scripting

Scripts for exporting backup from selected tables of Oracle DB

dear all please help me ! i need a script for exporting the selected tables of oracle database installed on CentOs. i waiting your response. thanks and regards (6 Replies)
Discussion started by: amirzargaran
6 Replies

10. UNIX for Advanced & Expert Users

Identify tables from Oracle sql scripts

Hi, Please let me know if you have any thoughts on how to read a table that has all the oracle sql files or shell scripts at the job and step level to identify all the tables that does merge, update, delete, insert, create, truncate, alter table (ALTER TABLE XYZ RENAME TO ABC) and call them out... (1 Reply)
Discussion started by: techmoris
1 Replies
OPHCRACK(1)							   User Commands						       OPHCRACK(1)

NAME
Ophcrack - a Microsoft Windows password cracker using rainbow tables. DESCRIPTION
Ophcrack is a Windows password cracker based on a time-memory trade-off using rainbow tables. This is a new variant of Hellman's original trade-off, with better performance. It recovers 99.9% of alphanumeric passwords in seconds. Ophcrack works for Windows NT/2000/XP/Vista. Ophcrack can be used with command line using the options below, or can be run as a pure graphical software. If you have installed ophrack-cli package, graphical interface is not available. SYNOPSIS
ophcrack [options] OPTIONS
-a disable audit mode (default) -A enable audit mode -b disable bruteforce -B enable bruteforce (default) -c <file> specify the config file to use -D display (lots of!) debugging information -d <dir> specify tables base directory -e do not display empty passwords -f <file> load hashes from the specified file (pwdump or session) -g disable GUI -h display this information -i hide usernames -I show usernames (default) -l <file> log all output to the specified file -n <num> specify the number of threads to use -o <file> write cracking output to file in pwdump format -q quiet mode -r launch the cracking when ophcrack starts (GUI only) -s disable session auto-saving -S <session_file> specify the file to use to automatically save the progress of the search -u display statistics when cracking ends -t table1[,a[,b,...]][:table2[,a[,b,...]]] specify which table to use in the directory given by -d -v verbose -w <dir> load hashes from encrypted SAM file in directory dir -x export data in CSV format to the file specified by -o EXAMPLES
ophcrack -g -d /path/to/tables -t xp_free_fast,0,3:vista_free -f in.txt Launch ophcrack in command line using tables 0 and 3 in /path/to/tables/xp_free_fast and all tables in /path/to/tables/vista_free and cracks hashes from pwdump file in.txt SEE ALSO
Homepage: http://ophcrack.sourceforge.net/ Free rainbow tables: http://ophcrack.sourceforge.net/tables.php AUTHOR
This manual page was written by Adam Cecile <gandalf@le-vert.net> for the Debian system (but may be used by others). Permission is granted to copy, distribute and/or modify this document under the terms of the GNU General Public License, Version 2 or any later version published by the Free Software Foundation On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL. 3.2.0 March 2009 OPHCRACK(1)
All times are GMT -4. The time now is 10:17 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy