Have you checked the path.
Physically is the file available in the said path?
Regards
K Vijayakumar
-----Original Message-----
From: Venmani K. Thirumavalavan [mailto:oracledba-ezmlmshield-x52679835.[Email address protected]
Sent: Wednesday, July 04, 2007 12:55 PM
To: LazyDBA Discussion
Subject: error in opening database file
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
---------------------------------------------------------------------
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
"Vijayakumar K - Engineer(Data Center) - SIS" <vijayakumar.[Email address protected]
___________________________________________________________________________
Visit us at www.sundaraminfotech.in
___________________________________________________________________________
This E-mail may contain privileged information and is intended solely for the addressee, and any disclosure of this information is strictly prohibited, and may be unlawful. If you have received this mail by mistake, please inform us immediately and delete this mail. Any information expressed in this mail does not necessarily reflect the views of SUNDARAM INFOTECH SOLUTIONS. As per SUNDARAM INFOTECH SOLUTIONS's policy, unencrypted mail via Internet is not considered secure.
___________________________________________________________________________
Oracle LazyDBA home page