Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> New columns in V$yablespace

New columns in V$yablespace

From: <zulmi_nri_at_yahoo.com>
Date: 14 Dec 2005 00:31:46 -0800
Message-ID: <1134549106.688033.186020@g14g2000cwa.googlegroups.com>


Hey

Regarding v$tablespace view there are three new columns added in new version of database 10G. These new columns are BIGFILE, FLASHBACK_ON and INCLUDED_IN_DATABASE_BACKUP.
Could someone inform me which type of information these new columns possess?
As well as after installation of 10G database using Database configuration Assistant,
Every time when we start the database all the accounts were locked except sys. How should we unlock these users account permanently? I know the command that is "Alter user system account unlock" but I issue every time when I start the database 10G.

Your information will be appreciated.

 Zulmi. Received on Wed Dec 14 2005 - 02:31:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US