The syntax for the CREATE TABLESPACE statement when creating a temporary tablespace is: CREATE [ SMALLFILE | BIGFILE ] TEMPORARY TABLESPACE tablespace_name [ TEMPFILE { [ 'filename' | 'ASM_filename' ] [ SIZE integer [ K | M | G | T | P | E ] ] [ REUSE ] [ AUTOEXTEND { OFF |...
Specify the datafiles to make up the permanent tablespace or the tempfiles to make up the temporary tablespace. Use the datafile_tempfile_spec form offile_specificationto create regular datafiles and tempfiles in an operating system file system or to create Automatic Storage Management disk group ...
Description of the illustration tablespace_encryption_spec.eps default_tablespace_params::= Description of the illustration default_tablespace_params.eps (default_table_compression::=,default_index_compression::=,inmemory_clause::=,ilm_clause::=—part ofCREATETABLEsyntax,storage_clause::=) ...
'ParallelAsmReadThreads': 123, 'ReadAheadBlocks': 123, 'AccessAlternateDirectly': True|False, 'UseAlternateFolderForOnline': True|False, 'OraclePathPrefix': 'string', 'UsePathPrefix': 'string', 'ReplacePathPrefix': True|False, 'EnableHomogenousTablespace': True|False, 'DirectPathNoLog': True|...
You cannot specify a locally managed temporary tablespace, including an undo tablespace, or a dictionary-managed temporary tablespace, as a user's default tablespace. See Also: CREATE TABLESPACEfor more information on tablespaces in general and undo tablespaces in particular ...
(parallel_pdb_creation_clause::=,default_tablespace::=,pdb_storage_clause::=,file_name_convert::=,service_name_convert::=,path_prefix_clause::=,tempfile_reuse_clause::=,user_tablespaces_clause::=,standbys_clause::=,logging_clause::=,create_file_dest_clause::=,keystore_clause::=,pdb_re...
The syntax for specifying datafiles for theSYSAUXtablespace is the same as that for specifying datafiles during tablespace creation using theCREATETABLESPACEstatement, whether you are storing files using Automatic Storage Management or in a file system or raw device. ...
DEFAULT TABLESPACE Clause Specify the default tablespace for objects that are created in the user's schema. If you omit this clause, then the user's objects are stored in the database default tablespace. If no default tablespace has been specified for the database, then the user's objects ...
You cannot specify a locally managed temporary tablespace, including an undo tablespace, or a dictionary-managed temporary tablespace, as a user's default tablespace. See Also: CREATE TABLESPACEfor more information on tablespaces in general and undo tablespaces in particular ...
You cannot specify a locally managed temporary tablespace, including an undo tablespace, or a dictionary-managed temporary tablespace, as a user's default tablespace. See Also: CREATE TABLESPACEfor more information on tablespaces in general and undo tablespaces in particular ...