Search Results

Hi All,

Please help

*****************
a=100 and run for loop that will minus 30 from 100 an will display value

run loop will run till display value will be 0

*****************
...

[oracle@localhost latest]$ cat check_tablespace.temp
USERS 5 960 18.75 0
SYSAUX 630 130688 20.2579365 ...

Thanks boss

working thanks a lot. salute to you

got out from one issue will face many more.

thanks for help

---------- Post updated at 12:17 AM ---------- Previous update was at 12:04 AM...

select file_name from dba_data_files where tablespace_name = 'SYSTEM^I^I^I^I';$
select file_name from dba_data_files where tablespace_name = 'SYSAUX^I^I^I^I';$

facing same error

cd /u01/script/latest/
rm -rf check_tablespace.temp datafiles.log sql.log tbs.sql tbs.temp
sqlplus -s / as sysdba << eof > /u01/script/latest/check_tablespace.temp
set pages 0
Select...

Hi Boss

Thanks a lot

but still issue is same

[oracle@localhost latest]$ cat tbs.sql
select file_name from dba_data_files where tablespace_name = SYSTEM---space--- ...

Hi ,

Can any one help me out how to remove space from below line
select file_name from dba_data_files where tablespace_name='SYSTEM ----space---- ';

i want as :
select file_name from...