SQLDIR Support

SQLDIR Support

If you have any issues with SQLDIR please post them here.

SQLDIR binaries and it's source code are available for download here:

   SQLDIR binaries and source code

> SQLDIR Support
> 
> If you have any issues with SQLDIR please post them here.
> 
> SQLDIR binaries and it's source code are available for download here:
> 
>    SQLDIR binaries and source code

Hi Vitaliy,

Am just writing to ask if it is possible to use SQLDIR without having to run 
sqldir_ddl.sql?

Reason am asking is ''coz sometimes some customers doesn't like creating new 
objects when you login to their databases. 

Any response will be very much appreciatd, Thanks in advance.

> Am just writing to ask if it is possible to use SQLDIR without having to 
> run sqldir_ddl.sql?

Yes of course -- just run x_dir_start.sql and it will display the SQLDIR menu.


I use a shortcut in a form of alias:

oradba.oracle-> alias sql
alias sql='cd /u01/app/oracle/admin/scripts/sqldir/sql; sqlplus dbatoolz/dbatoolz@lmon @x_dir_start.sql'
oradba.oracle-> sql

SQL*Plus: Release 9.2.0.5.0 - Production on Sat May 8 09:26:24 2010

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

username: system
password:
database: test
Connected.

Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
PL/SQL Release 9.2.0.7.0 - Production
CORE    9.2.0.7.0       Production
TNS for Solaris: Version 9.2.0.7.0 - Production
NLSRTL Version 9.2.0.7.0 - Production


Session altered.

+=====================================================+
|             SQLDIR SQL*Plus Menu v1.2               |
+=====================================================+

 ID Group Name                                     Cnt
--- --------------------------------------------- ----
 27 Favorite Scripts ............................   46
 11 Rollback ....................................    8
 26 Partitioning ................................   29
 13 Reverse Engineering .........................   11
  7 Tablespace ..................................   34
  3 APPS Concurrent Programs ....................   11
  0 TOTAL Number Of Scripts: ....................  300
 10 Redo Log ....................................   11
 23 Backup Management ...........................    5
 17 Statistics ..................................   18
 24 Parallel Query ..............................    4
  5 APPS Administration .........................   21
  1 APPS General ................................    8
 15 Table .......................................   29
 18 Storage Management ..........................   17
  8 Utility .....................................   25
  6 Data Files ..................................   17
 12 Maintenance .................................   24
  4 APPS Concurrent Managers ....................   13
  9 Index .......................................   12
 22 Segment Management ..........................   30
 14 SGA Maintenance .............................   19
  2 APPS Installation ...........................    9
 19 Database Init Parameters ....................    5
 16 User Management .............................   38
 21 Locks .......................................    8
 25 SQL Tracing Tuning ..........................   26
 20 Latches .....................................    6
Enter Group Id or to search Enter [s SEARCH_STRING] :

09:26:38 SYSTEM@test:genesis> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
oradba.oracle->