laconicamit
Last Activity: Dec 18 '07, 12:02 PM
Joined: Jul 11 '07
Location:
-
If you are installing Oracle 10g.. then you scott user must be locked. Please try Sys or System's user credentials instead, as described above.... -
Thank you!!
Many thanks for your advice....Leave a comment:
-
What happened to you Dear!! Why you are acting as Loser!!!
I wrote "Absolutely working Fine" can't you read that. I said I checked it in 9i/10g/11g. It is working beautifully fine.
One should be aware of all the releases (What I think, Don't know about you)
There is nothing to "Wake Up" and "HOPPING" into new release when you don't know the basics [:D]...Leave a comment:
-
DECODE in PLSQL: "Works Fine"
set serveroutput on;
DECLARE
emp_comm NUMBER;
BEGIN
SELECT DECODE(comm,NUL L,0) INTO emp_comm FROM emp WHERE empno=7900;
DBMS_OUTPUT.PUT _LINE(emp_comm) ;
END;
/
Please read the error message carefully, before you HOP to give a "Verdict"
CASE in PL/SQL: Absolutely Working Fine. (9i,10g,11g)
But It is...Leave a comment:
-
I found we cannot use CASE in PL/SQL.
We can use DECODE in PL/SQL.Leave a comment:
-
Thanks Sir,
Let me check and get back to you..
Many Thanks.. :)...Leave a comment:
-
That's what I am doing Mr. Patel.
I am simply looking for an answer that .. How we can extract the Binary Data which is stored in LONG RAW column of a Oracle table.
Now, if you will provide me the solution that how we can change the character based data to pdf..Then after sometime I will ask you .. How to get an image file extracted from a Binary stored data.
I am not questioning you knowledge and expertise....Leave a comment:
-
It dosen't required to answer everytime, atleast "NOT" if you haven't understood the question correctly.
What am I asking is A and you are replying me Z...
Thanks anyways!!!...Leave a comment:
-
Hi!
I hope you didn't understood me correctly. Let me explain you once more, I have actually loaded the binary data (.pdf file) to an Oracle 10g database table's LONG RAW column. Now, I want to extract that LONG RAW column containing (pdf file) and write another pdf file. Then I will compare the file which is generated now and the pdf file which I have loaded to verify my load.
So, for that I need a pl/sql function-SP. If not...Leave a comment:
-
How to extract from LONG RAW data in Oracle.
HI!
I have a binary data stored in a LONG RAW column in an Oracle table. The Binary data contains .pdf document. Can anybody please help me to write a function/SP which extracts that Binary data back to pdf document or to a text file?
Any help would be highly appreciated.
Thanks in Advance!!! -
HI! Can you please tell me the WAY how you make that data loss from Redo Log Buffer. Are you talking about instance crash and instance recovery after that?...Leave a comment:
-
Rebooted??? No way, they are in front on me. And as i said .... When I re-connect it get successfully connected with the specified node and I hope rebooting requires at least some amount of time to make all services up and specially in the case of RAC to make it available.
Well regarding Oracle Service or Listener service, hang issue. I am not sure about, i think this cannot be the issue. Can you please tell me the way to check Listener...Leave a comment:
-
TNSNAMES.ora is been perfectly entered and tnsping works fine. I tried it in both ways: entered IP address and Host name.
It dosen't give me any problem in connecting to the Db. However, when I make frequent connections it fetches me that error. As I said when I re-connect, it goes boom boom . I have seen my connection connecting to both instances simaltenously...Leave a comment:
-
ORA-12545: Connect failed because target host or object does not exist
HI!,
Using SQL+, when i try to connect to a server giving RAC_srv as service name. It get connected, However sometimes it throws me following error.
ORA-12545: Connect failed because target host or object does not exist
But when I try to re-connect it get successfullt connected.
My tns entries are fine and I am able to connect to the both of RAC nodes.
Has anynody faced this type... -
See,
To knw on which Tablespace, user had the permissions:
Eg.
Select tablespace_name from dba_ts_quotas where username=<usern ame>;
and if you want that user shud not have quota over those tablespace, you can simply alter that user:
Eg.
Alter user <username> quota 0 on <tablespace_nam e>;
I hope that solves your purpose, If I have assumed you...Leave a comment:
-
What is commit_delay & commit_siblings?
Can anyone please tell me the impact of uncommenting these two parameters of postgresql.conf ig file.
#commit_delay = 0 # range 0-100000, in microseconds
#commit_sibling s = 5 # range 1-1000
And is there any, auto commit setting can be done thru this? -
Is there no one intersted? Well, I thought there are some "exploring" attitude people enrolled with thescripts.com [:D]Leave a comment:
-
All About - PostgreSql
How actually the query executes in PostgreSql database. Different phases of execution and where actually the Datafiles, LogFiles and Control Files reside while installing PostGresSql in Linux Machine. Is there any feature like Replication exists in PostgreSql. However, this is open source but material availability is very rare. One more thing, while studying i found out that it had some System Catalog viz.. pg_user, pg_view, pg_tables... What I did,...
No activity results to display
Leave a comment: