Monthly Archives: ottobre 2014

Using  Invisible Indexes
  • 27
    Ott

Using Invisible Indexes

Table created. SQL> create index ind_TEST.index_tables on TEST.tables_empty (a) Index created. OWNER                          OBJECT_NAME                    OBJECT_TYPE ------------------------------ ------------------------------ ----------- TEST                           TABLES_EMPTY                   TABLE IND_TEST                       INDEX_TABLES                  INDEX   SQL> exec dbms_stats.gather_table_stats (ownname=>'TEST',tabname=>'TABLES_EMPTY',cascade=>TRUE); PL/SQL procedure successfully completed. SQL>  exec dbms_stats.gather_index_stats (ownname=>'IND_TEST',indname=>'INDEX_TABLES'); PL/SQL procedure successfully completed. SQL> conn ind_TEST Enter password: SQL>  explain plan for 2  select * from TEST.TABLES_EMPTY; SQL> @?/rdbms/admin/utlxpls   PLAN_TABLE_OUTPUT...

Read More
Oracle 11g, Account Password Expired
  • 20
    Ott

Oracle 11g, Account Password Expired

In the version of Oracle 11g, as the default user profile, leave enabled (for security reasons), the password expires. It often happens that we forgot to set this policy and we come across the term of its password, that is problematic, especially if it relates to utilities application (set in the codes of the programs). To overcome this...

Read More
Oracle External Table
  • 14
    Ott

Oracle External Table

Whit this feature you can access data in external sources as if it were a table in the database. Prior to release 10g external tables were read-only (9i); from release 10g external tables can also be written too. To use the external tables feature you must have knowledge of the file format and record format of the datafiles...

Read More
Creating Tablespaces in ASM
  • 6
    Ott

Creating Tablespaces in ASM

  When ASM creates a datafile for a permanent tablespace, the datafile is set to auto-extensible with an unlimited maximum size and 100 MB default size. You can use the AUTOEXTEND clause to override this default extensibility and the SIZE clause to override the default size. ASM applies attributes to the datafile, as specified in the system default...

Read More