Re: New columns in V$yablespace

zulmi_nri_at_yahoo.com wrote:
> 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.

BIGFILE ... the type of tablespace datafile FLASHBACK_ON ... is flashback enabled
INCLUDED_IN ... is the table included in a backup set

conn / as sysdba

alter user <username> account unlock;

If you don't have the sysdba privilege ... you are not the one who should be doing this.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)