Create statements create new objects. Create ClusterCreate a new cluster in the existing database.
Create ContextCreate a context and associate a namespace with external packages.
Create ControlfileCreate or recreate a control file.
Logfile
Character set
Create DatabaseCreates a database and erases any data in specified files
Default temp tablespace
Temp tablespace extent
Undo tablespace
Set time zone
Create Database LinkCreate a link to a remote database object.
Authenticated
Create DimensionCreate a dimension, a parent child relationship between column set pairs.
Level
Hierarchy
Join
Attribute
Create DirectoryCreate a directory.
Create FunctionCreate a standalone stored function or call.
Invoker rights
Parallel enable
Streaming
Call spec
Java declaration
C declaration
Create IndexCreate an index.
Cluster index
Table index
Bitmap join index
Index expression
Index attributes
Physical attributes
Logging
Key compression
Domain index
Global partitioned index
Global partitioning
Local partitioned index
On range partitioned table
On list partitioned table
Segment attributes
On hash partitioned table
On composite partitioned table
Index subpartition
Parallel
Create IndextypeCreate an indextype object.
Create JavaCreate a Java object containing a Java resource, class or source.
Invoker rights
Create LibraryCreate a callable object associated with an OS shared library.
Create Materialized ViewCreate a materialized view of the results of a query.
Materialized view properties
Prebuilt table
Scoped table ref constraint
Index organized table
Key compression
Index organized overflow
Create materialized view refresh
Segment attributes
Physical attributes
Logging
Data segment compression
Physical attributes
Object type column properties
Substitutable column
Nested table column properties
Varray column properties
LOB storage
LOB parameters
LOB partition storage
Parallel
Build
Create Materialized View LogCreate a materialized view log. New values
Create OperatorCreate an operator and define its bindings.
Binding
Implementation
Context
Using function
Create OutlineCreate an outline for the optimizer.
Create PackageCreate a package of stored procedures, functions and other objects.
Invoker rights
Create Package BodyCreate the body of a stored package.
Create pfileExport a binary parameter file into a text initialization file.
Create ProcedureCreate a standalone stored procedure.
Invoker rights
Call spec
Java declaration
C declaration
Create ProfileCreate a profile to set limits on database resources.
Resource parameters
Resource parameters
Create RoleCreate a role “ a grouping of a privileges that can be granted to users or other roles.
Create Rollback SegmentCreate a rollback segment.
Create SchemaCreate a multiple tables, views and grants as a single transaction.
Create SequenceCreate a sequence.
Create spfileCreate a binary server parameter file from a client initialization file.
Create SynonymCreate a synonym to a database object.
Create TableCreate a table.
Relational table
Object table
XMLType table
Relational properties
Object table substitution
Object properties
OID
OID index
Physical properties
Segment attributes
Physical attributes
Data segment compression
Table properties
Cloumn properties
Object type column properties
Substitutable column
Nested table column properties
Varray column properties
LOB storage
LOB parameters
Logging
LOB partition storage
XMLType column properties
XMLType storage
XMLSchema spec
Row movement
Index organized table
Mapping table
Key compression
Index organized overflow
Supplemental logging properties
External table
External data properties
Table partitioning
Range partitioning
Hash partitioning
List partitioning
Composite partitioning
Subpartition by hash
Individual hash partitions
Hash partitions by quantity
Subpartition by list
Subpartition template
List values
Range values
Table partition description
Partition level subpartition
Subpartition spec
Partitioning storage
Parallel
Enable disable
Using index
Global partitioned index
Global partitioning
Create TablespaceCreate a new tablespace.
Data segment compression
Extent management
Segment management
Create Temporary TablespaceCreate a new temporary tablespace.
Temp tablespace extent
Create TriggerCreate and enable a database trigger.
DML event
Referencing
Create TypeCreate the specifications for an object type. Use the CREATE TYPE BODY statement to actually assign the code for the type.
Create incomplete type
Create object type
Invoker rights
sqlj object type
sqlj object type attribute
Element specification
Inheritance
Subprogram
Procedure specification
Function specification
Constructor specification
Map order function spec
Return
sqlj object type sig
Pragma
Call specification
Java declaration
C declaration
Create varray type
Create nexted table type
Create Type BodyCreate the code for the methods defined by the CREATE TYPE statement.
Procedure declaration
Function declaration
Constructor declaration
Call specification
Java declaration
C declaration
Create UserCreate a new user and define storage, password, quotas and other details for the user.
Create ViewDefine a logical table or view of one or more tables or views.
Object view
XMLType view
XMLSchema spec
Subquery restriction
|