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.
>>
>>
>>
>>
>>