Hi, I am facing problem with Ora 03113. It will be of great help someone responding out there. The problem definition is : When i try to do single/bulk blob...
vish
gvishakha@...
Nov 6, 2001 10:11 am
129
Hallo All Where can I get hold of information describing the OracleInProcServer object (methods,properties,etc)? Thank you, Braamvh@......
Can anyone please explain me the concept of jndi with respect to oracle . One of my colleagues is trying to load jndi jar files into the oracle 8.1.7 database...
AMITH UPPAL
uppal_amith@...
Nov 9, 2001 5:40 pm
131
Hi all, I have one query. 1 select rownum, parentId pid,categoryId cid 2 from CategoryTbl 3 where parentId in (50,51,52,53,54) 4* order by 2 13:34:30...
vish
gvishakha@...
Nov 26, 2001 9:51 am
132
Hi, Pls help if you have worked on this query 1 / \ 2 3 4 / \ / \ 5 6 7 8 / \ 9 10 SQL> desc v3; Name Null? Type ... CID NOT NULL NUMBER PID NUMBER SQL> l ...
vishakha
vishakha@...
Nov 28, 2001 1:30 pm
133
I tried this one: - hot backup of my database with tag='TAG1' - added two new datafiles - hot backup of my database with tag='TAG2' - restore database from...
hi , try this one select a.CID from (select distinct CID from v3 start with PID=1 connect by PID=prior CID) a where not exists (select PID from v3 where...
Hi, Is there a way to connect to Oracle from Visual Basic without having an entry in the TNSNAMES.ORA file. Thanx, BIdar...
brao@...
Dec 2, 2001 8:13 pm
136
Hi Vishal, Thanks a lot, it works. Regards, Vishakha ... ...
vish
gvishakha@...
Dec 3, 2001 6:01 am
137
Hi, How are you restoring the Backup? I mean are you using the old (tag1) control file or new (tag2) The error is there because the tag1 backup did not have...
Mashruwala Sumedha, IBM
Sumedha.Mashruwala@...
Dec 5, 2001 4:29 am
138
Hi, I'm restoring/recovering with the following script: connect rcvcat 'rman8i/rman8i@RME0' connect target run { # Restore all datafiles, and recovers them...
I need some help if you have used context index. desc t(id number, clob_col clob); I have created context index on a clob column as: create index tidindx on...
vishakha
vishakha@...
Dec 7, 2001 8:21 am
140
Hi, As far as I remember, only Oracle programs who can do a ipc connection are able to connect to Oracle with the net8. Also it comes with another restriction,...
sudhi76
sudhi76@...
Dec 10, 2001 4:00 pm
141
Hi, You can bypass Oracle networking (net8) by using DataDirect's Connect ODBC drivers in your application. DataDirect's Connect ODBC 4.0 is a wire protocol...
Hi all, I am curious about the following question: Is there a way to see which users that are connected to the database AND use a certain application? Let's...
Dwight Looye
looyed@...
Dec 12, 2001 11:47 am
143
In my experience, you just have to learn what is visible for each application. When I look at a database where all the users are in the same application,...
Katherine Harms
kharms@...
Dec 12, 2001 7:10 pm
144
Hi, In all types of connection that I have seen, one can rely on the data returned by v$session view. Ofcourse most of my sighting was on NT platforms. Not...
Sudheendra Vijaykumar
sudhi76@...
Dec 13, 2001 6:51 pm
145
Hi Looye Dwight, It may be very difficult to know exactly who is running which application, but you can take some hints from the output of v$session. The...
Mashruwala Sumedha, IBM
Sumedha.Mashruwala@...
Dec 18, 2001 7:25 am
146
RRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR...
jkiyer67
jkiyer67@...
Dec 19, 2001 7:47 am
147
Hi, ora-3113 simply means that the client lost connection with the server process. Initial steps to do: + Check the alert.log of the db for any 7445 errors. +...
Sudheendra Vijaykumar
sudhi76@...
Dec 21, 2001 12:39 pm
148
Hi, I have an error when I want to connect my application VB on the Oracle basis... Error of execution 429: A ActiveX component cannot create an object...
traxx6666
gmercier@...
Dec 25, 2001 10:18 pm
149
Hi friends if you are interested in passing any IT certification like MCSE, MCSD, MCDBA, CCNA, CCNP, CCDA, CCIE, OCP ( Both DBA & Developer ), JAVA and ALL...
Hi All, Oratechsupportgroup will not appreciate these types of mails at all . This group is for helping people to solving problems, rather then advertisement...
Question ! When I take export of a particular schema , The dbms_jobs running in that schema are also exported . But when we try to import the whole schema to a...
AMITH UPPAL
uppal_amith@...
Jan 22, 2002 9:16 pm
152
Hi Amith, The job should be imported . It should not be imported if import schema does not have proper privileges. check the export dmp as imp...
Sameer Wadhwa
swadhwa@...
Jan 22, 2002 10:35 pm
153
Hi All, I am storing an XML file into a CLOB column. And I want to retrieve the XML from the CLOB and return a recordset of name and value pairs from the...
Sunil Mohite
sunilvmohite@...
Jan 23, 2002 3:42 am
154
Hi Sunil, This can be done easily by writing a java stored procedure. Just pass the XML in the COLB column as a parameter as type oracle.sql.CLOB and use the...
Sameer , I am importing the schema from coltstream to billrep . The import gives these errors ......this shows that the import tries to create the jobs in the...
AMITH UPPAL
uppal_amith@...
Jan 23, 2002 7:35 pm
156
Hi Amith, Sorry if i am understand this wrongly, Who is the owner of JOB, SYS or COLTSTREAM. If SYS is the owner then you will certainly get the error. Is...
Sameer Wadhwa
swadhwa@...
Jan 23, 2002 8:56 pm
157
... Hi Amith See the error : ORA-00001: unique constraint (SYS.I_JOB_JOB) violated ORA-06512: at "SYS.DBMS_IJOB", line 210 ORA-06512: at line 1 The error...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
