Some pages on Software Databases & Linux
Operating Systems Security Databases Database software Some Oracle utils Nice software Some Old pages
SQL guide PL/SQL guide Jersey and Open Source Linux File server Linux Firewalls Thin clients |
Create Public synonym Script. Everybody writes their own version of this script now and then. It reads the Oracle data dictionary to create synonyms for all objects for the current user. The script contains some comments and definitions to let you adopt it for different situations. This should be a trivial thing for anyone with basic knowledge about sqlplus and SQL.
To use it: Start and login to an Oracle database with SQLPlus, Start the script with: @@CreSyn
Create Grant to user Script. This is another script that everybody writes. It reads the Oracle data dictionary to create grants to a user for all objects for the current user. This script also contains some comments and definitions to make it possible to change it for different purposes. It should be a trivial thing to change for anyone with some knowledge about sqlplus/SQL.
To use it: Start and login to an Oracle database with SQLPlus, Start the script with: @@CreGrant
Drop and Create Sequences Script. Another script that creates two files. One to drop sequences and one to recreate them as they are right now. Edit the create file for specific values and you can use it for test purposes.
To use it: Start and login to an Oracle database with SQLPlus, Start the script with: @@DrpCreSeq
|
>> Page 1 |
Copyright(@)2003 www.Timehole.com. You may use and redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or later. |
|
I work with databases
 And OpenSource Sw
 I use fedora linux
For non-techies try: Ubuntu or PcLinuxOs Share information and knowledge!
 I'm based in Jersey, Available for assignments in all of Europe, On-Site or Remote. Call or mail me!
 |