tablespaces

Hi All,

I have this query to get the statements to resize my tablespaces. How do I get it to put a ' round the filename?

select 'alter tablespace ' ||file_name ||' resize 50M;' from dba_data_files


Cheers

Quote:

---

Originally posted by davey23uk
Hi All,

I have this query to get the statements to resize my tablespaces. How do I get it to put a ' round the filename?

select 'alter tablespace ''' ||file_name ||''' resize 50M;' from dba_data_files


Cheers

---

Jeff is my hero!

MH

[Edited by Mr.Hanky on 10-14-2002 at 09:18 AM]

thanks

Quote:

---

Originally posted by Mr.Hanky
Jeff is my hero!

MH

[Edited by Mr.Hanky on 10-14-2002 at 09:18 AM]

---

Yeah, yeah, yeah. http://www.dbasupport.com/forums/sho...threadid=18412