dankeshon!
"Ness" <aggb_nutrinti@inbox.lt> wrote in message news:h0qr3n$k26$1@trimpas.omnitel.net...
> ALTER SYSTEM SET log_archive_dest_2='LOCATION=USE_DB_RECOVERY_FILE_DEST2 
> QUOTA_SIZE=0';
> 
> 0 = vietos neriboja
> 
> 
> 
> "Toxis@ze_yvil_place" <tox@work.ble> wrote in message 
> news:h0qi8a$5c7$1@trimpas.omnitel.net...
>> dlia osobina typych (tobish man:) gal gali trumpai apshviest:
>> alter user dba? (ar instanco useris) quota unlimited on 
>> kuris_table_space'as?;
>> sorry uzh durna klausima:)"Ness" <aggb_nutrinti@inbox.lt> wrote in message 
>> news:h0qha9$3v8$1@trimpas.omnitel.net...
>>>> QUOTA_SIZE=2048
>>>
>>> pasididink quota arba ja visai nuimk. Paskui 30 kartu paleisk
>>> ---------
>>> alter system switch logfile;
>>> --------
>>>
>>> cia kad kiekvienas redo logas susiaktyvintu, nes ju pas tave 30 ir 
>>> dauguma
>>> invalidai.
>>> jei po visko dar bus like invalidu - restartuok instanca ir vel 
>>> suaktykvink
>>> kiekviena redo loga.
>>>
>>> mano manymu redo logu pas tave per daug. geriau maziau ir didesni.
>>>
>>>
>>>
>>>
>>> 
> 
>