1. Shell Programming and Scripting

I have a script which gives the output of schemas in Oracle DB : #!/bin/ksh ps -ef | grep -v grep | grep ora_pmon_$1 | wc -l | while read CONTROL do if ; then ORACLE_HOME=/u01/app/oracle/product/9.2.0 export ORACLE_HOME PATH=$ORACLE_HOME/bin:$PATH:/bin:/usr/bin:usr/local/bin:. ... (0 Replies)

2. Shell Programming and Scripting

Hi, I need my script to accept a column name and give all the tables and its schema. Any kind of help is appreciated... Thanks in advance... (2 Replies)

3. UNIX and Linux Applications

Need a help Schema browser in Toad not listing the tables when i connected to Oracle 11g schema did any body faced the issue... ? How to resolve the issue (0 Replies)

4. Emergency UNIX and Linux Support

Need a help ..Schema browser in Toad not listing the tables when i connected to Oracle 11g schema did any body faced the issue... ? How to resolve the issue.. I need it asap thats y posted here Thanks (5 Replies)

5. Cybersecurity

Hi guys, we are implementing new ldap in our organization exclusively for Linux authentication purposes. As we are new to the subject, I would appreciate help regarding which schema to use to create group of users and accounts / passwords entries? I see both schemas listed in subject above... (0 Replies)

6. Shell Programming and Scripting

In my Oracle db there are 4 schemas. All the username & passwords are stored in a text file. I am using a while loop to export all the schemas. It read the first line and doing the export. For all users it export one by one. But I need all the schemas will exported simultaneously. i.e. all the... (1 Reply)

7. UNIX for Dummies Questions & Answers

Hi All, I have a full oracle dump file that I have exported from a production server. I want to import a specific schema out of the full dump. Is that possible in oracle. What will be the command for that? (6 Replies)