You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for CREATE


1 to 20 of 7453 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


2 Day DBA, 10g Release 1 (10.1)

7 Administering Users and Security

Using a Shortcut to Create UsersIf you later want to create other users similar to user MYUSER, or another existing user, Oracle … provides a shortcut for doing so. On the Users page, you can create a user with the same attributes as … Create Like. Click Go. The Create User General page appears for a new user with the same attributes … providing

2 Day DBA, 10g Release 1 (10.1)

2 Installing Oracle and Building the Database

Using DBCA to Create a DatabaseSelect Create a Database on the DBCA Operations page to begin a wizard that enables you to … configure and create a database. During the interview, you are asked for your input on the following … enables you to select the type of database you want to create. By default, Oracle Corporation ships … extensive interview and it will

2 Day DBA, 10g Release 1 (10.1)

2 Installing Oracle and Building the Database

Using DBCA to Create and Configure a DatabaseChoices". Create Starter Database —Specify whether to create a starter database during the installation … . Oracle recommends that you create a starter database for first-time installations. You must … that you want to Create a starter database. If you select Do not create a starter database, then you

Developer's Guide, 10g Release 1 (10.1)

3 Oracle COM Automation Feature Core Functionality

CreateInstantiates a COM object in a COM Automation server. Syntax public void Create(String progID … ) public void Create(String progID, String serverName) Where Is progid the programmatic identifier (progID … ) of the COM Automation object to create. This character string describes the class of the COM … The COM Automation object

SQL Reference, 10g Release 1 (10.1)

CREATE PACKAGE

CREATE PACKAGEPurpose Use the CREATE PACKAGE statement to create the specification for a stored package, which is … subsequently, defines these objects. See Also: CREATE PACKAGE BODY for information on specifying the … implementation of the package CREATE FUNCTION and CREATE PROCEDURE for information on creating

SQL Reference, 10g Release 1 (10.1)

CREATE DIMENSION

CREATE DIMENSIONPurpose Use the CREATE DIMENSION statement to create a dimension. A dimension defines a parent … dimension_join_clause of CREATE DIMENSION, you must run the DBMS_OLAP. VALIDATE_DIMENSION procedure … . See Also: CREATE MATERIALIZED VIEW for more information on materialized views Oracle Data … To create

SQL Reference, 10g Release 1 (10.1)

CREATE USER

CREATE USERPurpose Use the CREATE USER statement to create and configure a database user, which is an account … have the CREATE USER system privilege. When you create a user with the CREATE USER statement, the … user's privilege domain is empty. To log on to Oracle Database, a user must have the CREATE

SQL Reference, 10g Release 1 (10.1)

CREATE TABLE

Restrictions on Temporary Tables Temporary tables cannot be partitioned, clustered, or index organized.…absolute maximum number of columns in a table is 1000. However, when you create an object table or a

SQL Reference, 10g Release 1 (10.1)

CREATE TRIGGER

Restrictions on Trigger ConditionsIf you specify this clause for a DML event trigger, then you must also specify FOR EACH ROW. Oracle Database evaluates this condition for each row affected by the triggering statement. You cannot specify trigger conditions for INSTEAD OF trigger statements. You can reference object columns or their attributes, or varray, nested table, or LOB columns. You cannot invoke PL/SQL functions or methods in

SQL Reference, 10g Release 1 (10.1)

CREATE LIBRARY

CREATE LIBRARYPurpose Use the CREATE LIBRARY statement to create a schema object associated with an operating … -system shared library. The name of this schema object can then be used in the call_spec of CREATE … FUNCTION or CREATE PROCEDURE statements, or when declaring a function or procedure in a package or type … Also:

SQL Reference, 10g Release 1 (10.1)

CREATE TRIGGER

Restrictions on BEFORE TriggersYou cannot specify a BEFORE trigger on a view or an object view. You can write to the: NEW value but not to the: OLD value. AFTER Specify AFTER to cause the database to fire the trigger after executing the triggering event. For row triggers, the trigger is fired after each affected row is changed.

SQL Reference, 10g Release 1 (10.1)

CREATE TRIGGER

Restrictions on Triggers on UPDATE OperationsLOB column in the UPDATE OF clause. See Also: AS subquery clause of CREATE VIEW for a list of … to fire. You can create triggers for these events on DATABASE or SCHEMA unless otherwise noted. You … can create BEFORE and AFTER triggers for these events. Oracle Database fires the trigger in the … . CREATE Specify

SQL Reference, 10g Release 1 (10.1)

CREATE DIMENSION

Restrictions on Dimension Level ColumnsAll of the columns in a level must come from the same table. If columns in different levels come from different tables, then you must specify the dimension_join_clause. The set of columns you specify must be unique to this level. The columns you specify cannot be specified in any other dimension. Each level_column must be non-. However, these columns need not have NOT NULL constraints. hierarchy_clause

SQL Reference, 10g Release 1 (10.1)

CREATE PROCEDURE

CREATE PROCEDUREPurpose Use the CREATE PROCEDURE statement to create a standalone stored procedure or a call … for information about registering external procedures CREATE FUNCTION for information specific to … functions, which are similar to procedures in many ways CREATE PACKAGE for information on creating … packages. The CREATE

SQL Reference, 10g Release 1 (10.1)

CREATE VIEW

Restrictions on the Defining Query of a Viewtable, then the view will not contain those columns until you re-create the view by issuing a CREATEcreate a view to be inherently updatable, or you can create an INSTEAD OF trigger on any view to make … delete base table rows. You can create a view to be inherently updatable, or you can create

SQL Reference, 10g Release 1 (10.1)

CREATE CONTROLFILE

CREATE CONTROLFILEthe CREATE CONTROLFILE statement to re-create a control file in one of the following cases: All … and open. An alternative to the CREATE CONTROLFILE statement is ALTER DATABASE BACKUP CONTROLFILE TO … TRACE, which generates a SQL script in the trace file to re-create the controlfile. If your database … controlfile.

Recovery Manager Reference, 10g Release 1 (10.1)

CREATE CATALOG

PurposeTo create a schema for the recovery catalog. Typically, you create this schema in a separate … Recovery Advanced User's Guide to learn how to create the recovery catalog

SQL Reference, 10g Release 1 (10.1)

CREATE TABLE

Restrictions on List SubpartitioningIn addition to the restrictions for composite partitioning in general (see composite_partitioning ), for list subpartitioning: You can specify only one subpartitioning key column. You must specify the list_values_clause, which is subject to the same requirements as at the table level. In the subpartition_template, you cannot specify the hash_subpartition_quantity clause. partition_level_subpartition

SQL Reference, 10g Release 1 (10.1)

CREATE TABLE

Notes on Composite Partitionsand if you have created a subpartition template, then the database uses the template to createCREATE TABLE statement, NOCACHE is the default In an ALTER TABLE statement, the existing value is not

Recovery Manager Reference, 10g Release 1 (10.1)

CREATE SCRIPT

Restrictions and Usage NotesNote the following restrictions: Execute CREATE SCRIPT only at the RMAN prompt, not within a RUN … the catalog database must be open. You cannot run CREATE SCRIPT once to create a local script, and … then use this same script on multiple target databases. If you want to create a global script, you … must connect