Script to list log path

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc

Poston Tue, 15 Apr 2008 2:09 pm

Someone would tell me how to do select to run out then, since the exit are ls \"log path\".
Need to list all automatically to see the permissions.

The select is this: SELECT ' ls-ultra ' || file_name \"##\" FROM dba_data_files WHERE tablespace_name IN (SELECT DISTINCT tablespace_name \"##\" FROM dba_rollback_segs WHERE tablespace_name = ' SYSTEM ') need in each output select já made a print on the screen of the ls.
Location: mogi-guaçu

Poston Tue, 29 Apr 2008 2:25 pm

play pro spool (record a text file) and then run this file with the @.

But in the select have to change part of \"ls\" putting the host command before e.g. \"host ls\"
Location: sp

Return to SQL

Who is online

Users browsing this forum: No registered users and 3 guests