Re: New columns in V$yablespace

What does the following column actually mean as u mentioned:

BIGFILE ... the type of tablespace datafile

Zulmi

DA Morgan a écrit :

> 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)
Received on Thu Dec 15 2005 - 02:32:26 CST