SQLDIR Support
| Topic ID: 1304 | |
| Created By: | 2006-DEC-06 19:32:15 [Vitaliy] |
| Updated By: | 2010-MAY-08 12:29:41 [Vitaliy] |
| Status: | Open |
| Severity: | Normal |
| Read Only: | No |
|
4663
2006-DEC-06 19:32:15
|
||||
|
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
[edited by: Vitaliy at 13:21 (CST) on Feb. 04, 2009]
|
11363
2010-MAY-08 05:35:13
|
||||
|
> 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.
|
11366
2010-MAY-08 12:29:22
|
||||
|
> 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->
[edited by: Vitaliy at 12:29 (CST) on May. 08, 2010]