zulmi_nri_at_yahoo.com wrote:
> ---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)
>>
>>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)
- Don't top posters
- Don't be lazy
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sun Dec 18 2005 - 14:49:18 CST