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...
I would not use ignore=y. This problem needs a real solution. The situation suggests that it would be a good idea to determine if the requirement is for...
Katherine Harms
kharms@...
Jan 24, 2002 5:04 pm
159
hello i am mallikarjuna raju from hyderabd i am interested in oracle database thank u...
I upgraded a server from windows NT 4.0 to Window 2000 server and now I cannot get to my oracle database. Most of the services are started. Does anyone have...
SAB9074
sab9074@...
Jan 24, 2002 6:13 pm
161
When you try to connect what error message do you receive? Katherine Harms Consultant, Peoplesoft Infrastructure EAS IT Infrastructure Consulting Practice ...
Katherine Harms
kharms@...
Jan 24, 2002 6:22 pm
162
Please provide the details including error number. Also your environment variables - ORACLE_HOME, ORACLE_SID etc... using set command from command prompt. ...
Varughese M
varughesem@...
Jan 24, 2002 6:51 pm
163
Jason , I got your point . but the situation is . The original schema is coltstream . I want to move everything from coltstream to another schema called...
AMITH UPPAL
uppal_amith@...
Jan 24, 2002 7:30 pm
164
Can you do like this execute sys.dbms_job.remove(<job id>); declare i as number; BEGIN sys.dbms_ijob.submit (job=>i,luser=>'BILLREP', ...
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.
