Chatee ahora con Soporte
Chat con el soporte

SQL Navigator for Oracle 8.1 - User Guide

Quick Overview Working With SQL Navigator Navigation Oracle Logon Code Editor Visual Object Editors Team Coding and Version Control Systems Modules, Windows And Dialogs
Analyze Tool Auto Describe Tool Benchmark Factory Bookmarks Dialog Capture Web Output Change Logon Password Dialog Code Analysis Code Assistant Code Road Map Code Templates Code Test Database Source Code Search Dialog DB Navigator Describe Difference Viewer Edit Data ER Diagram Explain Plan Tool Export Table Find and Replace Dialog Find objects Dialog Find Recycle Bin Objects Dialog Formatting Options HTML Viewer Import HTML as PL/SQL Import Table Java Manager Job Scheduler Locate In Tree Output Window PL/SQL Profiler Profile Manager Project Manager Publish Java to PL/SQL Quick Browse Rename Object Search Knowledge Xpert Select DB Object Dialog Server Output Server Side Installation Wizard Session Browser Source Preview SQL Modeler SQL Optimizer Task Manager Web Support Configuration Dialog Wrap Code
View | Preferences About Us

Export Table

Open the Export Tables window

Open the Export Tables window from Object Menu | Export Table.

TIP: Select the objects to be exported before you open the Export Tables window. Use for example DB Navigator, DB Explorer, Project Manager, a list of results after finding objects.

 

Select the tables to export (1)

In the Export Tables window, tables in the Selected Tables list are exported.

Ways to move tables to this list (from the Browse Table to Export list):

  • Double-click on a table.
  • Selecting one or more tables and click >.
  • Select one or more schemas and click >. This adds all tables in the selected schemas.
  • Click >>. This adds all tables in all schemas.
  • Select objects before you open the Export Tables window.

 

Select export options (2)

Option

Description

Objects to export

Select the objects you want exported from the database to the DMP file.

Additional Parameters
Field Description

Direct

Data is extracted directly, bypassing the SQL Command-processing layer. This method may be faster that a conventional path export.

Consistent

Uses the SET TRANSACTION READ ONLY statement to ensure the data does not change during the execution of the export command.

Select this parameter if you anticipate other applications will update the data after an export has started.

Note: Tables are usually exported in a single transaction. However, nested and partitioned tables may be exported as separate transactions. If nested or partitioned tables are being updated by other applications, the exported data may be inconsistent. To minimize this possibility without selecting the Consistent parameter, export those tables at a time when updates are not being performed.

Record

Records an incremental or cumulative export in the system tables SYS.INCEXP, SYS.INCFIL, and SYS.INCVID.

Compress
Selected Flags table data for consolidation into one initial extent upon import. If extent sizes are large (for example, because of the PCTINCREASE parameter), the allocated space will be larger than the space required to hold the data.
Not Selected Export uses the current storage parameters, including the values of initial extent size and next extent size. The values of the parameters may be the values specified in the CREATE TABLE or ALTER TABLE statements or the values modified by the database system. For example, the NEXT extent size value may be modified if the table grows and if the PCTINCREASE parameter is nonzero.

 

Note:

  • Although the actual consolidation is performed upon import, you can specify the COMPRESS parameter only when you export, not when you import. The Export utility, not the Import utility, generates the data definitions, including the storage parameter definitions. Therefore, if you do not select Compress when you export, you can import the data in consolidated form only.
  • Neither LOB data nor subpartition data is compressed. Rather, values of initial extent size and next extent size at the time of export are used.

Buffer size (leave blank for default)

The size, in bytes, of the buffer used to fetch rows. This parameter determines the maximum number of rows in an array fetched by Export.

Use the following formula to calculate the buffer size:

buffer_size = rows_in_array * maximum_row_size

If you specify zero, Export Tables fetches only one row at a time.

Tables with columns of type LOBs, LONG, BFILE, REF, ROWID, LOGICAL ROWID, or DATE are fetched one row at a time.

Note: See your Oracle operating system-specific documentation to determine the default value for this parameter.

Record Length

The length, in bytes, of the file record. The RECORDLENGTH parameter is necessary when you must transfer the export file to another operating system that uses a different default value.

If you do not define this parameter, it defaults to your platform-dependent value for buffer size.

You can set RECORDLENGTH to any value equal to or greater than your system's buffer size. (The highest value is 64 KB.)

Changing the RECORDLENGTH parameter affects only the size of data that accumulates before writing to the disk. It does not affect the operating system file block size.

You can use this parameter to specify the size of the Export I/O buffer.

Note: See your Oracle operating system-specific documentation to determine the proper value or how to create a file with a different record size.

Statistics

Select the type of database optimizer statistics to generate when the exported data is imported.

Provide a feedback dot each time n rows are exported

Export should display a progress meter in the form of a period for n number of rows exported.

For example, if you specify FEEDBACK=10, Export displays a period each time 10 rows are exported.

Note: The FEEDBACK value applies to all tables being exported; it cannot be set individually for each table.

Specify files
Field Description

Output file name (.dmp)

The names of the export dump files.

This field is mandatory.

Parameter file name (.dat)

A name for the file that contains a list of import parameters.

This field is mandatory.

Log file name (.log)

The name of the log file.

All informational and error messages are written to the log file.

 

Results (3)

When execution is complete there are three tabs in the Export Tables window. The results of the export are shown on the Output tab. The Log and Parameter file tabs show the contents of their respective files.

Find and Replace Dialog

Find or replace text strings in the current text file.

Note: Select Regular expressions if you want your strings to be recognized as Regular Expressions. Regular Expressions are a widely-used method of specifying patterns of text to search for. Special metacharacters allow you to specify, for instance, that a particular string you are looking for occurs at the beginning or end of a line, or contains >n< recurrences of a certain character.

Find objects Dialog

Find objects in any schema.

 

What To Search For

You can construct a search argument for any database object.

  • You can use wild-card characters %" and "_" (according to SQL LIKE operator definitions).
  • You can filter by schema, object type, date last modified and status.

TIP: To display a dynamic list of all objects in a schema

  1. In DB Navigator, select a schema node in the top level of the DB Navigator tree.
  2. Click Search | Find Objects.

 

Now Objects Are Found

Task Action

Describe

View a description of object structure ( index, cluster, procedure, function, or package).

Use Describe or Auto Describe Tool on the selected object.

Sort

Sort on any column (name, owner, type, creation/modification date, status) in ascending or descending order.

Click the column header.

Open the object for editing

Double click on the object.

See Visual Object Editors or the Code Editor for more information.

Locate in schema

Display the selected object in DB Navigator.

For more information, see Locate In Tree.

Batch selection and update

On selecting multiple objects you can

  • apply commands like Copy Text, Drop, Extract DDL, Compile, Get Metadata, Properties, Send to Code Analysis, Add to Project Manager, Enable, Disable, and Truncate to the entire batch of objects. For more information, see Object Menu.
  • drag the group of objects into a text editor or DB Navigator.

 

TIP: Other actions are available. Right-click on the object and select a command from the shortcut menu

Find Recycle Bin Objects Dialog

Search for objects in the recycle bin.

Note: Requires Oracle 10g or later.

 

What To Search For

You can construct a search argument for any database object.

  • You can use wild-card characters %" and "_" (according to SQL LIKE operator definitions).
  • You can filter by schema, object type, drop date and System Change Number (SCN).

 

Now Objects Are Found

Task Action

Sort

Sort on any column (name, owner, type, creation/modification date, status) in ascending or descending order.

Click the column header.

Open the object for editing

Double click on the object.

See Visual Object Editors or Code Editor for more information.

Batch selection and update

When multiple objects are selected, you can apply commands like Copy Text, Purge and Flashback to the entire batch of objects.

 

TIP: Other actions are available. Right-click on the object and select a command from the shortcut menu

Documentos relacionados

The document was helpful.

Seleccionar calificación

I easily found the information I needed.

Seleccionar calificación