Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: New columns in V$yablespace
---You can find information on them at http://tahiti.oracle.com.
This not fair. I just asked why BIGFILE is included in 10G and you were saying that to go to another side for getting the answer.
Looking forward to a humle reply on that forum.
Thanks
DA Morgan a écrit :
> zulmi_nri_at_yahoo.com wrote:
> > 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)
>
>