Hi DBAs,
This is an error that I'm getting. Please let me know the cause of it
ORA-01116: error in opening database file 24
ORA-01110: data file 24: '/fd1/oradata/tbl2/FD1P1/fdssrundat01.dbf'
ORA-27092: skgfofi: size of file exceeds file size limit of the process Additional information: 131071 Additional information: 256002
Thank You,
Regards,
Venmani KT
Direct: +91 44 6625 1343 | Mobile: +91 99401 64123 | VoIP: +6666 914 1343
Creating value that increases customer competitiveness
-----Original Message-----
From: Israel Laureano Lazcano [mailto:oracledba-ezmlmshield-x14989340.[Email address protected]
Sent: Tuesday, July 03, 2007 12:21 AM
To: LazyDBA Discussion
Subject: Re: any body help pl. output in single line
I think his query will do:
select A.id,A.name,to_char(A.dt,'DD/MM/YY') || to_char(B.dt,'DD/MM/YY')
from yyy_tab A, zzz_tab B
where A.id=B.id;
if it works for you, please use it as a basement for a more elaborate
query because I feel it's a little simplistic.
Israel the "DBA".
Mohan Rao escribió:
>HI Experts
>
>
>
>My query is below
>
>
>
>Select id,name,dt from yyy_tab
>
>union all
>
>select id,name,dt from zzz_tab
>
>
>
>output is coming like this
>
>--------------------
>
>Xxx pumps 28/06/07
>
>Xxx pumps 30/06/07
>
>
>
>But out put required is in this format any body help pl.
>
>
>
>Xxx pumps 28/06/07 30/06/07
>
>
>
>Pl help
>
>
>
>
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>
>
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Legal Disclaimer:
The information contained in this message may be privileged and confidential. It is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete or destroy any copy of this message
Oracle LazyDBA home page