Section courante

A propos

Section administrative du site

CREATE SHAPSHOT

 Créer un tire frappé
Oracle Database SQL  

Syntaxe

CREATE SHAPSHOT [schema.]mview
      [
             ORGANIZATION {HEAP [
                         PCTFREE int
                           PCTUSED int
                           INITRANS int
                           MAXTRANS int
                           STORAGE storage_clause
                           TABLESPACE tablespace
                 ] [COMPRESS int|NOCOMPRESS]
         | INDEX [
                         [
                                PCTFREE int
                                   PCTUSED int
                                   INITRANS int
                                   MAXTRANS int
                                   STORAGE storage_clause
                                   TABLESPACE tablespace
                        ]
                           {MAPPING TABLE | NOMAPPING}
                           [PCTTHRESHOLD int]
                           [COMPRESS int|NOCOMPRESS]
                           [ [INCLUDING column_name] OVERFLOW [
                                PCTFREE int
                                 PCTUSED int
                                   INITRANS int
                                   MAXTRANS int
                                   STORAGE storage_clause
                                   TABLESPACE tablespace
                        ] ]
                 ]
         | EXTERNAL [
                         ([TYPE access_driver_type]
                      DEFAULT DIRECTORY directory [ACCESS PARAMETERS {USING CLOB subquery | (opaque_format_spec) }]
                 LOCATION (directory:'location_specifier' [,directory2:'location_specifier2'...)
                 ) [REJECT LIMIT {int|UNLIMITED}]
                 ] }
          ]
         [USING INDEX [
                         PCTFREE int
                           PCTUSED int
                           INITRANS int
                           MAXTRANS int
                           STORAGE storage_clause
                           TABLESPACE tablespace
                 ]]
            [{REFRESH [refresh_options] | NEVER REFRESH]
               [FOR UPDATE] [{ENABLE|DISABLE} QUERY REWRITE]
                  AS subbquery;

Description

Cette instruction permet d'effectuer la création d'une vue matérialisé.

Voir également

Article - Les géants de l'informatique - Oracle

Dernière mise à jour : Lundi, le 11 mai 2015