-
编辑 删除
Oracle10g OFA
Table D–7 Hierarchical File Mapping for an Optimal Flexible Architecture InstallationDirectory Description/ Root directory/u01/ User data mount point 1/u01/app/ Subtree for application software/u01/app/oracle/ Oracle Base directory/u01/app/oracle/admin/ Subtree for database administration files/u
-
编辑 删除
When does 'NOLOGGING' attribute work on a table?
NOLOGGING is supported in only a subset of the locations that support LOGGING. Onlythe following operations support the NOLOGGING mode:DML:■ Direct-path INSERT (serial or parallel) resulting either from an INSERT or aMERGE statement. NOLOGGING is not applicable to any UPDATE operationsresulting from the MERGE statement.■ Direct Loader (SQL*Loader)DDL:■ CREATE TABLE ... AS SELECT■ CREATE TABLE ... LOB_storage_clause ... LOB_parameters ... NOCACHE |CACHE READS■ ALTER TABLE ... LOB_storage_cla
