nixCraft
Oracle "show databases" list
This is a discussion on Oracle "show databases" list within the Databases servers forums, part of the Mastering Servers category; How do I list all databases in Oracle 9i or 10i? TIA...
|
|||||||
| Register | FAQ | Members List | Calendar | Forgotten your password? | Mark Forums Read |
05-18-2007, 02:10 AM
|
|||
|
|||
Oracle "show databases" list
How do I list all databases in Oracle 9i or 10i?
TIA
__________________
Raj Linux rulz. I have never turned back in my life ; I shall not do so today.. haha 
|
| Sponsored Links | ||
|
|
|
05-18-2007, 02:21 AM
|
||||
|
||||
|
To List or view database list under Linux / UNIX oracle
To List or view database list under Linux / UNIX oracle use /etc/oratab file using cat command:
Code:
cat /etc/oratab Code:
cat /etc/oratab|grep -v "^#"|grep -v "N$"|cut -f1 -d: -s Code:
#!/bin/bash DBS=$(cat /etc/oratab|grep -v "^#"|grep -v "N$"|cut -f1 -d: -s) for d in $DBS echo $d done
|
 |
| Bookmarks |
| Tags |
| /etc/oratab , linux , oracle , oracle show databases , oratab , shell script , unix |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Redhat: Up2date " permission denied" while root | guarrand | Getting started tutorials | 2 | 07-03-2008 12:50 PM |
| How does "route add ..." fetch the interface automatically | Madhu | Linux software | 2 | 04-24-2008 06:28 PM |
| Does Redhat have "what" utility which can be used to display identification Info? | DCAO | Linux software | 2 | 10-30-2007 08:23 PM |
| [Commercial] SafeSquid "SPEED-BOOSTER" 4.2.0 Released | httpproxy | Networking, Firewalls and Security | 1 | 09-26-2007 09:05 PM |
| "permission denied" - Installing Lighttpd on RHEL 4 | b3n | Web servers | 3 | 08-29-2007 08:45 PM |
All times are GMT +5.5. The time now is 03:46 AM.
