Home » SQL & PL/SQL » Client Tools » toadprep.sql - Can Any one Get It For Me(TOAD)
toadprep.sql - Can Any one Get It For Me(TOAD) [message #12191] Thu, 06 May 2004 02:18 Go to next message
ERASER
Messages: 6
Registered: April 2004
Junior Member
Hi To all

While installing the new DB the toadprep.sql file has been lost.

Can any one get me a copy of the file.

At present i am working at TOAD 7.5.2.0

Thanks In Advance
Re: toadprep.sql - Can Any one Get It For Me(TOAD) [message #12198 is a reply to message #12191] Thu, 06 May 2004 08:44 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
This is from 7.6.0.11, but I don't think it has changed much, if any from your version:

REM This script was created by version 7.6.0.6 of the TOAD Server Side Objects Wizard
SET ECHO OFF
SET LINESIZE 200
DEFINE OWNER = ''
 
REM This script should be run as the TOAD user.
 
 
Prompt ============================================================================
Prompt Creating Explain Plan objects in  schema
Prompt ============================================================================
 
 
 
DEFINE tablespace_info = 'TABLESPACE &&USERS'
DEFINE tablespace_ind_info = 'TABLESPACE &&INDX'
 
Prompt Creating TABLE TOAD_PLAN_SQL
CREATE TABLE &&owner..toad_plan_sql (
username     VARCHAR2(30),
statement_id VARCHAR2(32),
timestamp    DATE,
statement   VARCHAR2(2000) )
&&tablespace_info; 
 
Prompt Creating INDEX TPSQL_IDX
CREATE UNIQUE INDEX &owner..tpsql_idx ON
&&owner..toad_plan_sql ( STATEMENT_ID )
&&tablespace_ind_info;
 
Prompt Creating TABLE TOAD_PLAN_TABLE
CREATE TABLE &&owner..toad_plan_table (
statement_id    VARCHAR2(32),
timestamp       DATE,
remarks         VARCHAR2(80),
operation       VARCHAR2(30),
options         VARCHAR2(30),
object_node     VARCHAR2(128),
object_owner    VARCHAR2(30),
object_name     VARCHAR2(30),
object_instance NUMBER,
object_type     VARCHAR2(30),
search_columns  NUMBER,
id              NUMBER,
cost            NUMBER,
parent_id       NUMBER,
position        NUMBER,
cardinality     NUMBER,
optimizer       VARCHAR2(255),
bytes           NUMBER,
other_tag       VARCHAR2(255),
partition_id    NUMBER,
partition_start VARCHAR2(255),
partition_stop  VARCHAR2(255),
distribution    VARCHAR2(30),
other           LONG)
&&tablespace_info ; 
 
Prompt Creating INDEX TPTBL_IDX
CREATE INDEX &&owner..tptbl_idx ON
&&owner..toad_plan_table ( STATEMENT_ID )
&&tablespace_ind_info;
 
 
Prompt ============================================================================
Prompt Adding public synonyms for Explain Plan objects
Prompt ============================================================================
 
 
 
Prompt Creating public synonym TOAD_PLAN_SQL
CREATE PUBLIC SYNONYM TOAD_PLAN_SQL FOR &&OWNER..TOAD_PLAN_SQL;
 
Prompt Creating public synonym TOAD_PLAN_TABLE
CREATE PUBLIC SYNONYM TOAD_PLAN_TABLE FOR &&OWNER..TOAD_PLAN_TABLE;
 
 
Prompt ============================================================================
Prompt Granting privileges to PUBLIC on Explain Plan tables
Prompt ============================================================================
 
 
Prompt Granting SELECT, INSERT, UPDATE, DELETE on TOAD_PLAN_SQL to PUBLIC
GRANT SELECT, INSERT, UPDATE, DELETE ON &&OWNER..TOAD_PLAN_SQL TO PUBLIC;
 
Prompt Granting SELECT, INSERT, UPDATE, DELETE on TOAD_PLAN_TABLE to PUBLIC
GRANT SELECT, INSERT, UPDATE, DELETE ON &&OWNER..TOAD_PLAN_TABLE TO PUBLIC;
Re: toadprep.sql - Can Any one Get It For Me(TOAD) [message #12205 is a reply to message #12198] Fri, 07 May 2004 00:30 Go to previous message
ERASER
Messages: 6
Registered: April 2004
Junior Member
very kind of you todd barry
Previous Topic: Shocked with the behaviour of TOAD for Nested IF
Next Topic: TOAD software installation
Goto Forum:
  


Current Time: Tue Aug 04 15:43:37 CDT 2020