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)
Please do not top post.
Oracle now provides a second type of data file for very large
tablespaces. You can find information on them at http://tahiti.oracle.com.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Dec 15 2005 - 14:35:37 CST