Results for table


61 to 120 of 17397 results. Prev  Next
Results per page:  20 |  40  | 60


Database PL/SQL Packages and Types Reference, 10g Release 2 (10.2)

DBMS_DEBUG

INDEX_TABLE Table TypeThis type is used by GET_INDEXES to return the available indexes for an indexed table. Syntax TYPE … index_table IS table of BINARY_INTEGER INDEX BY BINARY_INTEGER;

Database Utilities, 10g Release 2 (10.2)

SQL*Loader Control File Reference

Specifying Table NamesThe INTO TABLE clause of the LOAD DATA statement enables you to identify tables, fields, and … specification of fields and datatypes is described in later sections. INTO TABLE Clause Among its many … functions, the INTO TABLE clause enables you to specify the table into which you load data. To load … multiple

Database Performance Tuning Guide, 10g Release 2 (10.2)

Managing Optimizer Statistics

14.5.4 Locking Statistics for a Table or SchemaStatistics for a table or schema can be locked. Once statistics are locked, no modifications can be

Database Performance Tuning Guide, 10g Release 2 (10.2)

Instance Tuning Using Performance Views

10.2.3 Table of Wait Events and Potential CausesTable 10-1 links wait events to possible causes and gives an overview of the Oracle data that could … be most useful to review next. Table 10-1 Wait Events and Potential Causes

Database Utilities, 10g Release 2 (10.2)

Loading Objects, LOBs, and Collections

Loading a Parent Table Separately from Its Child TableWhen you load a table that contains a nested table column, it may be possible to load the parent … table separately from the child table. You can load the parent and child tables independently if the … are in the datafile with the data). Example 10-25 illustrates how to load a parent table with user

Database Concepts, 10g Release 2 (10.2)

Data Integrity

DML Statement Issued Against Parent Table Issued Against Child Tablerows in the child table without a referenced parent key value. Allowed if the new foreign key value … still references a referenced key value. DELETE No Action Allowed if no rows in the child table … deleted in the parent table. Inserts into the parent table do not require any locks on the child … table.

Database Data Warehousing Guide, 10g Release 2 (10.2)

Loading and Transformation

Transforming Data Using Table FunctionsTable functions provide the support for pipelined and parallel execution of transformations … . What is a Table Function? A table function is defined as a function that can produce a set of rows as … output. Additionally, table functions can take a set of rows as input. Prior to Oracle9 i, PL/SQL … not limited

Database PL/SQL Packages and Types Reference, 10g Release 2 (10.2)

DBMS_STREAMS_TABLESPACE_ADM

Table 109-2 FILE Attributesusing the SQL statement CREATE DIRECTORY. Syntax TYPE DIRECTORY_OBJECT_SET IS TABLE OF VARCHAR2(32 … ), file_name VARCHAR2(4000)); Attributes Table 109-2 FILE Attributes Attribute Description directory_object … associated with the directory object FILE_SET Type Contains one or more files. Syntax TYPE FILE_SET IS TABLE … . Syntax

Database Reference, 10g Release 2 (10.2)

Descriptions of Wait Events

free global transaction table entryThe session is waiting for a free slot in the global transaction table (used by the Distributed … tries The number of times the session tried to find a free slot in the global transaction table

Database Concepts, 10g Release 2 (10.2)

Schema Objects

How Table Data Is StoredWhen you create a table, Oracle automatically allocates a data segment in a tablespace to hold the … data segment. Oracle stores data for a clustered table in the data segment created for the cluster … table is created or altered. The storage parameters set for the cluster always control the storage … clustered table)

Database Utilities, 10g Release 2 (10.2)

Original Export and Import

Table Objects: Order of ImportTable objects are imported as they are read from the export file. The export file contains objects … in the following order: Type definitions Table definitions Table data Table indexes Integrity … (once when it is originally inserted and again during the import). For example, if the emp table has

Database Concepts, 10g Release 2 (10.2)

Partitioned Tables and Indexes

When to Partition a TableHere are some suggestions for when to partition a table: Tables greater than 2GB should always be … newest partition. A typical example is a historical table where only the current month's data is updatable and the other 11 months are read only.

Database Utilities, 10g Release 2 (10.2)

Data Pump Export

Performing a Table-Mode ExportExample 2-1 shows a table-mode export, specified using the TABLES parameter. Issue the following … Data Pump export command to perform a table export of the tables employees and jobs from the human … resources ( hr ) schema: Example 2-1 Performing a Table-Mode Export expdp hr/hr TABLES=employees,jobs

Database Security Guide, 10g Release 2 (10.2)

Configuring and Administering Auditing

The SYS.AUD$ Auditing Table: Exampleon sys.aud$ by access; Audit succeeded. SQL> truncate table sys.aud$; Table truncated. SQL> SQL

Database Concepts, 10g Release 2 (10.2)

Glossary

tableBasic unit of data storage in an Oracle database. Table data is stored in rows and columns. See Also: column, row

Database Utilities, 10g Release 2 (10.2)

External Tables Concepts

Datatype Conversion During External Table UseWhen data is moved into or out of an external table, it is possible that the same column will have … data is unloaded into an external table and it is the destination when data is loaded from an external … table. The external table: When data is unloaded into an external table, the data from the database

Database Installation Guide for Microsoft Windows Itanium (64-Bit), 10g Release 2 (10.2)

Installing Oracle Database

Table 3-1 Oracle Universal Installer WindowsThe subsequent windows that appear, which are listed in Table 3-1, depend on the installation … after you have installed Oracle Database. Table 3-1 Oracle Universal Installer Windows Window

Database Installation Guide for Microsoft Windows (32-Bit), 10g Release 2 (10.2)

Installing Oracle Database

Table 3-1 Oracle Universal Installer WindowsAdvanced installation methods The subsequent windows that appear, which are listed in Table 3-1, depend … about tasks that you must complete after you have installed Oracle Database. Table 3-1 Oracle

Database Utilities, 10g Release 2 (10.2)

SQL*Loader Control File Reference

Benefits of Using Multiple INTO TABLE ClausesMultiple INTO TABLE clauses enable you to: Load data into different tables Extract multiple logical … input row object subtypes In the first case, it is common for the INTO TABLE clauses to refer to … the same table. This section illustrates the different ways to use multiple INTO TABLE clauses and … shows you

Database Utilities, 10g Release 2 (10.2)

Data Pump Import

Performing a Data-Only Table-Mode ImportExample 3-1 shows how to perform a data-only table-mode import of the table named employees. It … uses the dump file created in Example 2-1. Example 3-1 Performing a Data-Only Table-Mode Import > impdp … =DATA_ONLY parameter filters out any database object definitions (metadata). Only table row data is loaded.

Database Installation Guide for Microsoft Windows (x64), 10g Release 2 (10.2)

Installing Oracle Database

Table 3-1 Oracle Universal Installer WindowsAdvanced installation methods The subsequent windows that appear, which are listed in Table 3-1, depend … after you have installed Oracle Database. Table 3-1 Oracle Universal Installer Windows Window

Database New Features Guide, 10g Release 2 (10.2)

Oracle Database 10g New Features

1.15.8 Adding, Merging, or Splitting Table PartitionsYou can add, merge, and split table partitions in a version-enabled table by using the alter_option parameter to the AlterVersionedTable procedure.

Database Utilities, 10g Release 2 (10.2)

Original Export and Import

Table-Level and Partition-Level ImportYou can import tables, partitions, and subpartitions in the following ways: Table-level Import … loading data into an existing table. See IGNORE for more information. Guidelines for Using Table-Level … Import For each specified table, table-level Import imports all rows of the table.

Database PL/SQL Packages and Types Reference, 10g Release 2 (10.2)

DBMS_METADATA

Data Structures - Object and Table TypesThe DBMS_METADATA package defines, in the SYS schema, the following OBJECT and TABLE types. CREATE … TABLE OF sys.ku$_parsed_item / CREATE PUBLIC SYNONYM ku$_parsed_items FOR sys.ku$_parsed_items … SYNONYM ku$_ddl FOR sys.ku$_ddl; CREATE TYPE sys.ku$_ddls IS TABLE OF sys.ku$_ddl / CREATE PUBLIC SYNONYM … $_multi_ddls IS TABLE

Database Utilities, 10g Release 2 (10.2)

Using LogMiner to Analyze Redo Log Files

Unsupported Datatypes and Table Storage AttributesLogMiner does not support these datatypes and table storage attributes: BFILE datatype Simple and … nested abstract datatypes ( ADT s) Collections (nested tables and VARRAY s) Object refs XMLTYPE datatype Tables using table compression

Database Data Warehousing Guide, 10g Release 2 (10.2)

SQL for Analysis and Reporting

Filling Gaps in an Inventory TableAn inventory table typically tracks quantity of units available for various products. This table is … sparse: it only stores a row for a product when there is an event. For a sales table, the event is … a sale, and for the inventory table, the event is a change in quantity available for a product. For … example,

Database PL/SQL Packages and Types Reference, 10g Release 2 (10.2)

DBMS_AQ

Table 16-3 Type Name Attributesnames can be up to 30 bytes long. Queue names and queue table names can be up to 24 bytes long. Type … := object_type | \"RAW\"; Attributes Table 16-3 Type Name Attributes Attribute Description object_type … , Oracle Streams AQ creates a queue table with a LOB column as the payload repository. The … storage_clause parameter during

Database Concepts, 10g Release 2 (10.2)

Object Datatypes and Object Views

Updates of Nested Table Columns in ViewsA nested table can be modified by inserting new elements and updating or deleting existing elements … . Nested table columns that are virtual or synthesized, as in a view, are not usually updatable. To … trigger defined on a nested table column of a view is fired when the column is modified. If the entire … table

Database Utilities, 10g Release 2 (10.2)

Original Export and Import

Table-Level and Partition-Level ExportYou can export tables, partitions, and subpartitions in the following ways: Table-level Export … partitions or subpartitions can be imported selectively. Table-Level Export In table-level Export … , you can export an entire table (partitioned or nonpartitioned) along with its indexes and other … table-dependent

Database Utilities, 10g Release 2 (10.2)

Original Export and Import

Example Export Sessions in Table ModeIn table mode, you can export table data or the table definitions. (If no rows are exported, the … CREATE TABLE statement is placed in the export file, with grants and indexes, if they are specified … .) A user with the EXP_FULL_DATABASE role can use table mode to export tables from any user's schema

Database Utilities, 10g Release 2 (10.2)

Using LogMiner to Analyze Redo Log Files

Supported Datatypes and Table Storage AttributesLogMiner supports the following datatypes and table storage attributes: CHAR NCHAR VARCHAR2 and

Database Utilities, 10g Release 2 (10.2)

Field List Reference

Using POSITION with Multiple Table LoadsIn a multiple table load, you specify multiple INTO TABLE clauses. When you specify POSITION(*) for … the first column of the first table, the position is calculated relative to the beginning of the … is calculated relative to the last column of the last table loaded. Thus, when a subsequent INTO … TABLE

Text Reference, 10g Release 2 (10.2)

Oracle Text Result Tables

Gist TableA Gist table stores one row for each Gist/theme summary generated by CTX_DOC.GIST. Gist tables can … : Table A-9 Gist Table Column Name Type Description QUERY_ID NUMBER Query ID. POV VARCHAR2(80) Document

Text Reference, 10g Release 2 (10.2)

Oracle Text Result Tables

Highlight TableA highlight table stores offset and length information for highlighted terms in a document. This … specified: Table A-10 Highlight Table Column Name Type Description QUERY_ID NUMBER The identifier for the … results generated by a particular call to CTX_DOC. HIGHLIGHT (only populated when table is used to

Streams Concepts and Administration, 10g Release 2 (10.2)

How Rules Are Used in Streams

Table RulesWhen you use a rule to specify a Streams task that is relevant only for an individual table, you … are specifying a table rule. You can specify a table rule for DML changes, a table rule for DDL … changes, or a table rule for each type of change to a specific table (two rules total).

Text Reference, 10g Release 2 (10.2)

Oracle Text Result Tables

EXPLAIN TableTable A-1 describes the structure of the table to which CTX_QUERY. EXPLAIN writes its results … . Table A-1 EXPLAIN Result Table Column Name Datatype Description EXPLAIN_ID VARCHAR2(30) The value of the … operation performed. Refer to Table A-2 for possible values. OPTIONS VARCHAR2(30) Characters that

Text Reference, 10g Release 2 (10.2)

Oracle Text Result Tables

Markup TableA markup table stores documents in plain text or HTML format with the query terms in the documents … specified: Table A-11 Markup Table Column Name Type Description QUERY_ID NUMBER The identifier for the … results generated by a particular call to CTX_DOC.MARKUP (only populated when table is used to store

Ultra Search Administrator's Guide, 10g Release 2 (10.2)

Understanding the Oracle Ultra Search Administration Tool

Table SourcesA table source represents content in a database table or view. The database table or view can … Table Sources To create a table source, click Create Table Source, and follow these steps: Specify a … table source name, and the name of the database link, schema, and table.

SQL*Plus User's Guide and Reference, 10g Release 2 (10.2)

SQL*Plus Security

PRODUCT_USER_PROFILE TableSQL*Plus uses the PRODUCT_USER_PROFILE (PUP) table, a table in the SYSTEM account, to provide … commands and user roles. DBAs can use the PUP table to disable certain SQL and SQL*Plus commands in the … change their database privileges. SQL*Plus reads restrictions from the PUP table when a user logs in … table

Text Reference, 10g Release 2 (10.2)

Oracle Text Result Tables

Filter TableA filter table stores one row for each filtered document returned by CTX_DOC. FILTER. Filtered … processed through the filter defined for the text column and the results are stored in the filter table … and datatypes as specified: Table A-8 FILTER Result Table Column Name Type Description QUERY_ID … when table

Text Reference, 10g Release 2 (10.2)

Oracle Text Result Tables

Theme TableA theme table stores one row for each theme generated by CTX_DOC. THEMES. The value stored in the … specified: Table A-12 Theme Table Column Name Type Description QUERY_ID NUMBER Query ID THEME

Text Reference, 10g Release 2 (10.2)

Oracle Text Result Tables

HFEEDBACK TableTable A-4 describes the table to which CTX_QUERY. HFEEDBACK writes its results. Table A-4 HFEEDBACK Results Table

Text Reference, 10g Release 2 (10.2)

Oracle Text Result Tables

Token TableA token table stores the text tokens for a document as output by the CTX_DOC.TOKENS procedure … specified. Table A-13 Token Table Column Name Type Description QUERY_ID NUMBER The identifier for … the results generated by a particular call to CTX_DOC. HIGHLIGHT (only populated when table is used

Database Data Warehousing Guide, 10g Release 2 (10.2)

Change Data Capture

Datatypes and Table Structures Supported for Synchronous Change Data CaptureData Capture does not support the following table structures: Source tables that are temporary

Database Utilities, 10g Release 2 (10.2)

Data Pump Export

Estimating Disk Space Needed in a Table-Mode Exportconsumed in a table-mode export, without actually performing the export operation. Issue the following … locations. Example 2-3 Estimating Disk Space Needed in a Table-Mode Export > expdp hr/hr DIRECTORY … printed in the log file and displayed on the client's standard output device. The estimate is for table row data only; it does not

Database Concepts, 10g Release 2 (10.2)

Data Concurrency and Consistency

DML Statement Row Locks? Mode of Table LockSELECT... FROM table     INSERT INTO table... X RX UPDATE table... X RX DELETE FROM table... X … RX SELECT... FROM table...    FOR UPDATE OF... X RS LOCK TABLE table IN...     ROW SHARE MODE … . Therefore, other transactions can query and update a table

Database Utilities, 10g Release 2 (10.2)

Conventional and Direct Path Loads

Direct Path Load of a Partitioned or Subpartitioned TableWhen loading a partitioned or subpartitioned table, SQL*Loader partitions the rows and maintains … subpartitioned table can be quite resource-intensive for tables with many partitions or subpartitions. Note: If

Database Utilities, 10g Release 2 (10.2)

SQL*Loader Control File Reference

Calculating Bind Array Size for Multiple INTO TABLE ClausesWhen calculating a bind array size for a control file that has multiple INTO TABLE clauses … , calculate as if the INTO TABLE clauses were not present. Imagine all of the fields listed in the control … field in the data record is mentioned in multiple INTO TABLE clauses, additional space in the bind

Database Utilities, 10g Release 2 (10.2)

SQL*Loader Concepts

Conventional Path Loads, Direct Path Loads, and External Table LoadsSQL*Loader provides the following methods to load data: Conventional Path Loads Direct Path Loads External Table Loads

Database Utilities, 10g Release 2 (10.2)

Original Export and Import

Object Table Mode User Mode Full Database Mode Tablespace ModeAnalyze cluster No Yes Yes No Analyze tables/statistics Yes Yes Yes Yes Application contexts No No Yes No Auditing information Yes Yes Yes No B-tree, bitmap, domain function-based indexes Yes Foot 1 

Database Data Warehousing Guide, 10g Release 2 (10.2)

Change Data Capture

Datatypes and Table Structures Supported for Asynchronous Change Data CaptureChange Data Capture does not support the following table structures: Source tables that are temporary

Database Concepts, 10g Release 2 (10.2)

Backup and Recovery

When to Use CREATE TABLE AS SELECT RecoveryTo do an out of place restore of the data, perform a CTAS ( CREATE TABLE AS SELECT … AS OF …) using … the Flashback Query SQL \"AS OF …\" clause. For example, to create a copy of the table as of a … specific time: CREATE TABLE old_emp AS SELECT * FROM employees AS OF TIMESTAMP '2002-02-05 14:15:00' For … out of place creation

Database PL/SQL Packages and Types Reference, 10g Release 2 (10.2)

DBMS_AQ

Table 16-4 Oracle Streams AQ PL/SQL Callback AttributesNUMBER); Attributes Table 16-4 Oracle Streams AQ PL/SQL Callback Attributes Attribute Description

Database Backup and Recovery Reference, 10g Release 2 (10.2)

RMAN Commands

Table 2-3 How FLASHBACK Responds to Datafile Operationsdepending on the nature of the status change. Refer to Table 2-3 for details. If the FLASHBACK DATABASE … them. Table 2-3 How FLASHBACK Responds to Datafile Operations If this datafile operation occurred

Database Utilities, 10g Release 2 (10.2)

External Tables Concepts

Example: Creating and Loading an External Table Using ORACLE_LOADERload an external table. A traditional table named emp is defined along with an external table named … emp_load. The external data is then loaded into an internal table. Assume your.dat file looks as … DIRECTORY ext_tab_dir TO SCOTT; Create a traditional table named emp: CREATE TABLE

Database Administrator's Guide, 10g Release 2 (10.2)

Managing Schema Objects

Using DROP and CREATEYou can drop a table and then re-create the table. For example, the following statements drop and … then re-create the emp table: DROP TABLE emp; CREATE TABLE emp (... ); When dropping and re-creating … a table or cluster, all associated indexes, integrity constraints, and triggers are

Database Administrator's Guide, 10g Release 2 (10.2)

Managing Tables

Creating TablesTo create a new table in your schema, you must have the CREATE TABLE system privilege. To create a … table in another user's schema, you must have the CREATE ANY TABLE system privilege. Additionally … , the owner of the table must have a quota for the tablespace that contains the table,

Database Administrator's Guide, 10g Release 2 (10.2)

Managing Partitioned Tables and Indexes

Maintaining Partitioned Tablestables and indexes. Table 17-1 lists maintenance operations that can be performed on table partitions … (or subpartitions) and, for each type of partitioning, lists the specific clause of the ALTER TABLE … statement that is used to perform that maintenance operation. Table 17-1 ALTER TABLE Maintenance

Spatial Topology and Network Data Models, 10g Release 2 (10.2)

Network Data Model Overview

5.8.4 Path-Link TableFor each path table (described in Section 5.8.3 ), you must create a path-link table. Each row in … the path-link table uniquely identifies a link within a path in a network; that is, each combination … path-link table is not significant. Each path-link table contains the columns described in Table

Ultra Search Administrator's Guide, 10g Release 2 (10.2)

Tuning and Performance in Oracle Ultra Search

Table Data Source SynchronizationOracle Ultra Search provides a logging mechanism to optimize crawling of table sources. Using this





Was this page helpful?

Integrated Cloud Applications & Platform Services