Toad Use Quick Start (reprint)

Source: Internet
Author: User
Tags error handling execution file size functions sql table definition version oracle database
Quick Start
Toad Use Quick Start

Directory

A A summary of Toad function
Two System Requirements
Three Installation Guide
Four Quick Start
1. Introduction to the usage of Schema browser
2. Introduction to the use of SQL editor
3. Introduction to the usage of Procedure editor
4. How to make the Plsql debug
5. How to use Sqlab Xpert to optimize SQL
6. How to use SQL Modeler to write queries
7. How to use the DBA features of Toad

A summary of Toad function

During the development of Oracle applications, accessing database objects and writing SQL programs is tedious and time-consuming, and the day-to-day management of the database requires a lot of SQL scripts to complete. Quest software provides an efficient Oracle Application development tool-TOAD (Tools of Oracle Application developers). In the new version of Toad, the DBA module is also included to help the DBA complete a number of day-to-day management tasks. It is the most important feature is easy to use, access speed. With Toad, we can quickly access the database through a graphical user interface to complete complex SQL and Pl/sql code editing and testing. Designed specifically for developers by Oracle development specialists, Toad is a powerful, compact, and specialized pl/sql development environment.
Toad mainly has the following characteristics:
Mode browsing:
The Mode browsing feature allows us to quickly access the data dictionary, browsing tables, indexes, and stored procedures in the database. Toad provides fast access to the database, uses extremely convenient, the user interface is concise, the structure arrangement is reasonable. When we click on a separate database object, Toad immediately displays the details of this object. For example, when we click on a table for a database, all of the indexes, constraints, stored procedures, SQL statements, and other tables associated with this table are displayed in the same interface. To simplify operations, users can manipulate database objects in the Browse window.

SQL Editor:
The main function of the SQL Editor is to edit, run, and adjust SQL statements. TOAD's advanced editing window includes a number of features to increase the level of production that developers write SQL statements. For example, simply generate a code template, automatically discover the contents of the package and the name of the column before writing SQL, and so on.
The SQL Editor includes an edit window and a Run Results window that allows developers to test the results of the run during the editing process. The SQL Editor includes not only standard editing commands, but also some enhancements, such as fields in a quick query table, formatting the contents of an SQL statement, and so on. This window can handle large to 4GB content and is useful for large development projects. Handy bookmarks make it easy for developers to find relevant locations. You can provide user-defined configuration functionality in the Run Results window, support long and long raw columns, and unload data to disk, print data, edit data, and so on.

Stored Procedure Editor:
The main function of the stored procedure editor is to edit, compile, test, debug stored procedures, and triggers. Toad provides syntax identification, error identification, and many other features that are easy to use, such as displaying table names, column names, and Oracle functions in pop-up windows. Unlike other pl/sql editing tools, TOAD allows you to manipulate multiple database objects in one file, compile an object, compile multiple objects, compile to the current cursor, and compile from the cursor. The stored procedure stops to the problematic statement when there is an error running. Users can use shortcuts or templates to quickly write pl/sql, or to generate their own templates as needed. You can easily edit with toad, such as setting bookmarks, uncomment, format SQL statements, and so on.

Pl/sql Debugger Option:
Toad provides easy-to-use Pl/sql debugging capabilities to save developers valuable time for development and testing in large projects, and to improve the quality of application development. In the process of developing a stored procedure, Toad can edit, debug, and run code line by row. The runtime can input parameters according to need, observe the changes of related parameters to check the correctness of the stored procedure. During the modal process, Toad can display all breakpoints, parameters, call stacks, and output parameters through a window. With Toad, it is very easy to detect errors in stored procedures, and developers can run PL/SQL statements to identify the problem step-by-step. A debugging session can be performed concurrently with other program sessions.

Sqlab Xpert Option:
Help developers optimize SQL, provide them with a variety of optimization model SQL execution plans, and be able to give recommendations for optimization, compare the actual results of SQL operations in various modes, and help developers develop efficient code with real speed.

Toad can also plug a number of other products, such as pl/formatter, revealnet knowledge Base, SQL impact, and so on, which can be closely integrated with the Toad, together provide a perfect integrated development environment. The new version also adds a DBA module that toad the scope of the product.


Second, the system requirements:
Client:
Üwindows 95/98/nt/2000 Both English and Chinese can be
• Fully installed Sql*net 2.0 or Net8
Disk: General installation requires about 20M of space, depending on the selected modules and installation of different ways, at least 5M of disk space (read from the network server)
• Memory: Windows 9x/me:16m Memory; Windows Nt/2000:min 32M]
The Ütuning module requires additional 25M space

Server side:
Üoracle 7.3 or higher, on any hardware platform.
u need a DBA user account

Three Installation:
1. Three types of installation options:
A) TOAD and Personal Configuration Files to PC
The default installation option completes a full client-side installation and copies all required files to the local toad directory.
Most users should choose to use this installation method.
b) Personal Config Files to PC, read TOAD from Network Server
Reading the Toad program from a network server, installing some custom files on the local computer, and creating shortcuts to server files is generally not recommended and requires that the network server be configured.
c) TOAD to network Server
Install TOAD on a network server so that other users can perform personal Config Files to PCs, read TOAD from network server this way.
2. Depending on the features you need to use, you need to run some scripts (all under the Toad\temps directory)
If you need to use Toad to view the execution plan, you must run the script preptoad.sql or Notoad.sql
N Run Preptoad.sql If you want to create a toad user to store Toad objects that need to be used.
N Run Notoad.sql If you want to build the object that Toad needs to use in the current connected user mode.
n Note that if you choose to create a toad this user, you need to modify the script to specify the user's default table space and temporary tablespace.
u need to use Oracle8i Profile Analyzer and must run Toadprofiler.sql
u need to enhance toad security and must run Toadsecurity.sql

Four, Toad use Quick Start
1. Schema Browser:
Schema Browser is a very characteristic module of toad. With the help of schema browser, it is easy to browse all kinds of database objects within database, such as tables, indexes, sequences, stored procedures, etc., and can easily pour out DDL statements and make various modifications and reconstruction work. To navigate to a class of objects, this Column object allows the operation to be automatically listed.
Characteristics:
L SUPPORT the new, view, and modify of all objects in the Oracle database, integrating the functionality required to manage almost all database objects.
-> object class-> object-> object can manipulate properties-> object-related information to organize, very organized, easy to locate objects, also can see all the objects you need relevant information.
L for tables:
I. Complete table-building wizard, do not enter the lengthy syntax, more comprehensive for you to consider.
Ii. You can modify the various logical and physical properties of the table, modify the properties of the columns, add columns, delete columns (in oracle8i), modify the physical storage properties of the table, Truncate,drop, and so on.
Iii. A complete DDL statement can be generated to build the table, including storage information, permission information, constraints, indexes, triggers, and so on, which are hard to do.
Iv. it is convenient to analyze the table, view all the information on the table, and conditionally pour out the data in the table, and save it as a SQL statement.
V. can be convenient to reorganize the table, can complete exp/imp do not do things, and less human participation, more secure.

L for views, stored procedures:
I. You can save statements that establish views, stored procedures as text,
Ii. recompile the failed view, stored procedure, modify the definition statement of the view, and so on. Easy to view the stored procedures of the code, interdependence, permission information, etc. save as text, and so on.
L Rollback segment,
I. Simple and clear online,offline state, easy to online/offline operation
Ii. detailed rollback segment physical information and current state.
Iii. easy to modify physical storage properties

L Table Space:
I. tablespace map; Visual display data physical distribution on the table space
Ii. Intuitive view of the use of each table space, the remaining space, fragmentation and other information
III. Various ALTER operations can be performed: online, offline, adding data files, changing data file size, changing physical storage properties, etc.
L also have complete operational support for other database objects.

2. SQL Editor:
A three ways to activate SQL Editor:
I. After connecting to the database, Toad automatically opens the SQL Editor window.
Ii. Click on the leftmost button on the General toolbar
Iii. from menu bar: Database-> SQL Editor
b) Features:
L allows multiple edit windows to be opened simultaneously, editing multiple SQL statements simultaneously
L Support simultaneous connection to multiple databases while operating on multiple databases
L Allow editing of sql,plsql,java,html and text
l Use the Bookmark function to quickly locate a statement in a large number of SQL statements
The SQL Editor itself has a powerful editing capability that makes it easy to edit SQL statements.
L powerful shortcut key support and toolbar Quick button support, more efficient writing (many shortcuts can be defined by themselves, in view->options->sql editor)
L The ability to intelligently speculate on the code that needs to be entered according to the preceding conditions, and to be able to do some level of code intelligence filling
L position the mouse over the table/view/stored procedure name, press F4, you can open the Object Description window, easy to view the table and view definition, stored procedure source code,
L Very easy analysis of SQL statements its execution plan: Click the button on the toolbar to see the results of explain plans
L Support Partial sql*plus command, can easily execute a large number of database scripts written for Sql*plus
L can make a comprehensive analysis of the current SQL statement through Sqlab Xpert, give a variety of reasonable tuning advice, just click the Tuning button on the toolbar:
L can easily save, open and run SQL scripts
L SUPPORT the modification of the query results
L can save the query results in a variety of formats, such as HTML, plain text, XLS, etc.
L easily get a list of SQL functions and usage descriptions (Show SQL Help Window button)
L can view the execution of SQL statements: through the Autotrace window below, see the actual execution results and execution efficiency of the SQL statement.
L Support Historical SQL (F8): It is convenient to query the previously executed SQL without having to re-enter it repeatedly.
L can execute anonymous blocks, stored procedures, and see the results of dbms_output from the window below, such as:

3. Stored Procedure Editor
A several ways to open the stored procedure writer:
L Click the Third button on the Total menu bar:
L Click on Database-> Procedure Editor,
L can be invoked through schema browser.
b) Some features and advantages:
1. Powerful custom settings: from the display of reserved words, to automatic replacement, to the definition of various shortcuts, and so on, more familiar with the more comfortable.
2.
3. Automatically use different colors to display SQL and Pl/sql keywords, the syntax is clear, can be customized according to their own custom various types of keyword specific display mode. You can customize the stored procedure template, in the new stored procedures, the automatic generation of the framework of the program can easily invoke Schema Browser, positioning the mouse on an object, F4,schema Browser Open the object's detailed description, to help smooth rapid development of the program. Support for code AutoCorrect, such as input ndf, automatically replace with No_data_found, enter the automatic replacement of the, similar automatic replacement can also modify and add.
7. Easy to the left line number display, click the left line number to achieve the Debug breakpoint Add/Remove
8. Support for a variety of shortcut keys, including not only common editing operations, but also the support of plsql blocks that you define (define shortcuts yourself). If you can define CTRL+SHIFT+D: pop-up all plsql block type, you can choose.
9. Can be in an integrated development environment, while coding, while debugging, without multiple switching
10. Easy to open multiple stored procedures at the same time, quickly switch through the page
11. Quickly compile stored procedures, quickly locate errors, and choose whether to compile dependent stored procedures at the same time
12. Built-in to Pl/formatter, you can format stored procedures with Pl/formatter, and you can provide a summary analysis of stored procedures and recommendations for modification
Pl/formatter can format the existing stored procedures, so that all stored procedures are consistent with the same coding standards, so as to improve the readability of the program, to avoid the different people write the style of the module is very difference.
Pl/formatter also helps to improve program modularity, enhance the clarity of the program's structure, and enhance the sharing of SQL.
Pl/formatter can also help complete management between Pl/sql and Oracle versions.














13. Built-in revealnet knowledge Base, click the right mouse button to open, quickly get technical support to solve technical problems
Npl/sql:
n contains answers to problems that may be encountered throughout the development process
Ncode Library: A large number of rigorous Pl/sql code examples and ready-made procedures, complete source Code provides
N various error handling modules available for reference, various character date functions
N contains more than 1400 topics
Nadmin:
N Answers 80% Common questions in the daily work of the DBA, covering over 2,400 topics
N from network to performance optimization, from backup back to error message, readily available
Example: What happens when you encounter a stored procedure that is not valid?
4. How do I debug a stored procedure?
u need toad separate debug option (Standard Version does not have this option)
To debug a stored procedure with Toad, you must install the Oracle System Package: Dbms_debug, and you must install the Oracle Probe API v2.0 or a higher version.
U integrated in Stored Precedure Editor, you can debug while writing side, greatly improve the development efficiency
When you open procedure Editor, the Debug menu activates and you can start debug work.
U allows for row-by-line debugging of stored procedures, breakpoint debugging, and debugging of triggers.
U can have breakpoint support, support watch variable, allow runtime to change value of variable
U allows debug support for multi-tier calls
Specific examples of debugging steps:
1. Click on the Third button in the menu bar: Open Procedure Editor
2. Click on the Procedure Editor menu bar button to bring up stored procedures that need to be debugged
3. Click the button on the toolbar, enter the parameters you want to pass in, or click the button on the toolbar if you don't want to pass in the argument: Start debugging directly, and enter the incoming parameters as follows:

4. Click the menu bar button: You can step through, or you can define a breakpoint, run directly to the breakpoint in step, and the current statement will display a high brightness while the stored procedure is running, and position the mouse pointer over the variable, Toad automatically displays the variable's current value.

5. You can abort the execution of the program at any time, just click Debug->halt Execution, or the button on the menu bar, you can abort the execution of the program
6. When you encounter a stored procedure to invoke another stored procedure, you can choose to skip (step over), so that you run the called stored procedure directly, return the call result, continue debugging the stored procedure, or you can select trace into, so that the invoked stored procedure is opened. Further further debug the called child stored procedure. If you need to keep debug information, you should choose compile dependencies with debug information at compile time, which is the button on the far right of the procedure Editor toolbar.
7. Support for real-time tracking of variables: Using watch:
You can track a variable in real time before you run it, or when you run it: Add Watch, position the mouse over the variable, and then click Debug->add Watch at Cursor, which appears on the Debug status window and in real time counter the current value of the variable. As in the figure above the variable v_empname. You can run the time to modify
8. Breakpoint Support:
Click the line number where the stored procedure requires a breakpoint, the row color turns red, the input parameters, click the Execute button, you can run directly to the breakpoint, you do not have to track by line, more efficient debugging.
Debug option also supports conditional breakpoints, which stop at that place only when the condition is met, otherwise it will continue to run as if there were no such breakpoint.

?? Pay attention to Dbms_output. The results of the put_line are not present until the execution of the program is completed, and there is no result during the execution of the program.


4. How do I tune a stored procedure with Sqlab Xpert?
We know that the most important step in Oralce database optimization is the optimization of SQL. With the help of no specialized tools such as Toad, SQL optimization is a very difficult and tedious task, and requires an in-depth understanding of Oracle and superb Oracle tuning skills. Using Toad's Sqlab Xpert Tuning module enables our average developers to perform expert-level analysis of SQL very quickly and precisely
In SQL Editor and procedure editor, select the SQL statements that need to be debugged (Sqlab Xpert can only debug Select,insert, update,delete statements) and copy to SQL Editor. Then click on the Tuning button on the toolbar, Toad automatically opens the Sqlab xpert window, captures the current SQL statement, and converts it to a statement in explain plan format.
The first time you open Xpert, Toad will prompt you to install some server-side tables, views, and packages, which can be stored in a specified table space (such as tools). Can simply follow the prompts step by step to do it. If the system does not allow Job (job_queue_process=0), Toad prompts some parts will not be installed now, you can ignore. After the installation is complete, you can choose to allow some non-DBA users to also use the Toad Sqlab Xpert Tuning feature.
After the installation is complete, Toad will prompt you with some questions about the optimization goal, you can choose to reset each time, or set it up, and use this setting. Of course, if you need to, you can change the Sqlab Option Xpert window administration and preference under the reset.
Example:
The following SQL statement involves the correlation between multiple tables, and there is some complexity that we can use Toad's sqlab xpert option to help analyze:
Select A.name. B.name, C.emp_name
From DEP A, manager b,emp C
where A.dep_no=c.dep_no
and b.manag_id=c.manag_id
and c.emp_no=3
We copy this SQL into the SQL editor, click the tuning button above and toad Open the Sqlab xpert option window.
The following figure:

From the above diagram we can see in terms of: in various optimization modes, what is the execution plan for the SQL statement, Toad gives each of the specific steps for each execution plan, the cost of each step, the data involved in the table, etc. if the SQL Access table has not been parsed, Toad will be displayed with a red warning, and it is convenient for you to analyze the table, collect statistics, rebuild the index, etc. to help the optimizer make the best possible choice. The current analysis results can be saved in its database for later calls.
We can also ask for help with Sqlab automatic optimization function: Click on original SQL below the Auto Tune button, Toad will perform the results according to TKPROF analysis (of course, this requires you in the Initsid.ora set up a good utl_file_dir, If the server is on a UNIX machine, you also need to get trace files via FTP, with some small settings.
Automatic optimization is a very efficient comparison of the actual running of all execution plans, and gives a comparison of the actual execution time, as shown in the following figure:

We can also get toad to give practical optimization advice: Click Original SQL, click the advice button below, toad make reasonable recommendations based on the analysis of SQL and the results of execution:
Such as:
1. Put tables and indexes into two different table spaces, because we didn't specify the using index clause when we created the table, plus the constraints, so the tables and indexes were built on the user's default table space.
2. Analysis of table EMP,DEP and manager, collection of the latest statistics to facilitate the CBO to get the best implementation plan
3. Create an index on the appropriate column: EMP manag_id and Dep_no. This can greatly reduce the cost of a full table scan when there is a large amount of data in the table.


5. SQL Modeler:
SQL Modeler can help developers write complex SQL statements easily, and can write complex SQL statements simply by dragging the mouse.
Several ways to open SQL Modeler:
I. Menu bar Database-> SQL Modeler, opening windows
II. Click the Fourth button on the toolbar to open the SQL Modeler window
The window consists of three main parts:
N Table Selection: The rightmost section, which is used to select the table that is used in the FROM clause. Drag to the left area or double-click to select the table.
n Table Model Area: A graphical display of the associated relationships between tables and tables that are selected.
n Generate SQL Region: This shows the SQL statement for the query created in a graphical way,

In SQL Modeler, you also support explain plan for the generated SQL, debug SQL performance, run SQL, see if you have the desired results, save the generated statements, or paste the statements into the SQL editor.

With the help of SQL Modeler, even entry-level programmers can write complex and efficient SQL queries.
such as the following example;

Build Step:
1. Select the table emp, DEP, manager
2. Using the mouse to hold the EMP emp_name and Emp_no, DEP's name,manager name
3. Double-click the emp_no Condition column of the criteria window, pop the window, and enter the query criteria, such as emp_no=3
4. Because the result does not want Emp_no to appear, double-click the visible of the Emp_no column, set to False
5. So out of the query you need, you can now run the query to get results, analyze the query SQL, or open the SQL in the SQL Editor, or save it as a SQL model file, or further processing, such as add sorting, summary, and so on.

Functions of DBA:
Toad's ability to manage the day-to-day management of DBAs is powerful enough to help DBAs do a lot of daily work safely and quickly, as well as some toad-specific gadgets that can make it difficult to do some common methods. The following are probably the main features of each of the common modules:
A) Database Monitor
Provides intuitive Oracle database health, including the following details:
You can see logical io, physical IO, number of sessions in each state, utilization of SGA, usage of shared pools, waiting conditions for various events, and changes in events over time
b) Instance Monitor
I. can be used to check all the nodes, listener, and the running state and version of the database defined in the local Tnsnames.ora file.
Ii. can remotely start and close the database (if password authentication is set)
c) Unix Monitor:
I can monitor the running conditions of UNIX machines such as detailed machine start-up time, CPU utilization, major processes and resources used by these processes, major disk IO, and so on.
D) Trace/kill session
I. Easy to view all connected user related information: such as terminal, program, connection time, etc.
Ii. Track a user, view the SQL statements executed by the user, and view the execution plan for the statement.
Iii. convenient access to the lock object of the system, there is nothing waiting for other transactions to release the lock, and can easily find out what the user waiting for what the end of what the user executed what SQL.
Iv. View the use status of the rollback segment, what user, what statement, what rollback segment used, how many reads and writes, etc.
e) Oracle Parameter
I can easily see the Oracle system parameters: whether the default value, a brief description of the role of the parameters, whether alter Session/alter system can be dynamically changed, for those parameters can be dynamically changed, you can double-click the mouse to modify

f) Nls_parameter:
I. Easy to view the NLS parameter values at the session,instance,database level,
Ii. the NLS parameter values of the session can be dynamically modified

g) Extents
I. You can view the detailed storage of tables and indexes under a user,
Ii. find those tables and indexes that occupy a lot of space and consider using the appropriate countermeasures, such as partitioning
Iii. find those tables and indexes that are about to reach max_extents and correct them in time
IV. Found those indexes and tables in the same table space, and can be corrected in time.

h) tablespace
I. Intuitive view of the utilization of each table space, total space, used space, remaining but with space and the default storage parameters, and the table space needs to be collated and other information
Ii. View the status of each table space, the data files that comprise it, and the details of each data file
Iii. view the objects that exist in each tablespace and the detailed storage characteristics of those objects
i) tablespace Map:
I. Graphical display table space in each table/index occupied by the space, the size of each segment, segment whether continuous and other information, very intuitive
Ii.
j) Server Statistics:
I can be very intuitive to see the overall operation of the system, rapid positioning system bottlenecks
Ii. You can view the status of each of the system-wide wait events and see the status of each connection session.
k) Pinned Code:
I. We know that frequently executed large stored procedures are best to pin, so that you can avoid the memory being swapped out by Oracle, avoid dynamic loading, and avoid flush shared pool.
Ii. depending on the size of each module and the number of executions, decide whether or not to pin a stored procedure. A button is done.
L) Control Files:
You can see which control files are in the current system, as well as the details of the control file internal records.
(is actually v$controlfile, v$controlfile_record_section)
m) Redo Log Manager:
I can easily view the log group, the current log, each group inside the member name, size, convenient to add, delete log group, switch the current log, the log archive for specific control.
II. You can do almost all of the redo log operations in this interface.
N) Repair chained rows:
I. Chained rows affect system performance and are considered in system performance, and Chained rows need to be repaired to normal tables. Using Repaie chained rows, you can easily do this. Select the table you want to analyze, and then analyze it to see if there are any chained rows, and if so, click Repair,toad to help you fix those chained rows.
O) Identify space deficits
If a 1659,1653 error occurs on the system, it is an unqualified DBA. But there is a certain degree of difficulty in anticipating these mistakes in real time. With this gadget Toad, a bit of a table space knows whether the remaining free space in the tablespace allows any table to extend to the next extent. And can correct the problem directly after discovering the problem.

p) Estimate Table/index Size
I. In the physical planning of the database, the definition of the table/Index storage clause is very important and affects the system. But without any tools, it is not easy to define a reasonable storage clause for the table.
Ii. in Toad, there are tools to help you reasonably define the storage of your table/index:
1. You can define the number of data that you want to store in your future table
2. Various estimation methods:
(a) Define the size of the table (most accurate, but slower) based on an analysis of the existing data
b Define the size of the table based on the table definition data type
(c) Estimating size based on data previously analyzed in the data dictionary (needs to be analyzed recently)

Q Analyze All Tables
I. CBO SQL requires the CBO to provide the most optimized execution path to improve the execution efficiency of the program, but if the table does not update the statistics of the table after a lot of DML operation, then the CBO can not choose the most effective execution path, resulting in low program execution efficiency.
II. Manual Analysis table more troublesome, one to do.
Iii. using the Toad analyze AllTables This tool, you can analyze all the tables below the whole pattern at once, and have rich control options, including whether to use an estimate or a complete, to analyze the index at the same time, to estimate, how much percentage to use.
R) Rebuild Table
I. When the data in the table is repeatedly heavily DML, and the Pctfree and pctused definitions are unreasonable, the table can become very fragmented, take up a lot of extent, and the index can be quite fragmented, resulting in a fairly low efficiency.
The traditional way is to solve this problem through EXP/IMP, but the steps are more troublesome, and the manual operation also has certain danger.
III. Use the Rebuild Table tool, easy to handle, and can manually modify some of the exp/imp can not be modified by parameters, such as freelists, Freelists Group, tablespace,initial, etc., can also change the name of the column.
s) Relocate Index
I. We know that tables and indexes generally need to be stored separately in different table spaces, which is easier to manage and improves performance, because tables and indexes can be accessed simultaneously.
Ii. But in fact, many times, because of such reasons, the index is often neglected to store this basic concept, such as the creation of primary key constraints without the using index clause, and later disable/enable the PRIMARY KEY constraint/uniqueness constraints, etc. Will cause the index to be stored directly in the same table space as the table.
Iii. manually discovering these indexes, and then moving them one by one is cumbersome and error prone, and in toad it is easy to find those improperly stored indexes based on user/table space, move them in bulk, and allow you to redefine the stored clauses of the index.
T) Generate Schema Scripts:
I. A DDL statement that can be used to generate all/part of the object under the entire user. You can save the result as an SQL statement or Save as a toad custom format.
Ii. can be used to replicate the table structure, (Exp/imp has a very serious flaw, that is, from a large database inverted table structure, can not be imported into a small database, because it contains the original table storage information, even if you choose Rows=n, also in the import of the database to occupy considerable space)
u) Compare Schema:
I. At the time of development, sometimes at the same time in several development libraries, but the last two libraries are not exactly the same structure, it is difficult to compare
Ii. with this function of toad, you can compare all objects (including stored procedures) below the schema (user) of the two database, and you can select specific comparisons.
III. Can be compared by directly opening two connections to the respective database, or according to the files generated by Toad generate Schame scripts.
IV. You can directly generate a SQL script that synchronizes two databases, giving a summary of the differences and detailed reports.
--------------------------------------------------------------------------------

Almost learning Toad's only Chinese usage instructions, I can not find a better than this, special to share with you.
Reproduced, can not find the source. If the original person has a problem, I'll cut this out. ^_^



Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.