Oracle

Oracle text
10.1.0.2, Windows 2000 I have created an oracle text query. I create the index on a full table and it works. When I add new rows they are not used. Is this a known bug. What is the metalink number? Thank you Monty ... 10 Oct 2005 19:04

ORA-1652: unable to extend temp segment by 512 in tablespace
I created a database called desksite and a user as create user insite_adm identified by testing grant CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE SYNONYM to insite_adm; create tablespace insite datafile 'E:\oracle\oradata\insite\insite_data.dbf' size 100M extent management local uniform size 4M ... 11 Oct 2005 14:57

ORA-12518 Listener could not hand off connection
Background: Fresh install of oracle 10g on WindowsXP for a development enviroment. This computer is a laptop that moves between domains/ips. I used DBCA to create the database while I was attached to my work IP. This instance is setup in a dedicated server mode. Everything worked just fine at work but when I got h... 10 Oct 2005 04:58

How to upgrade a DB from 9.2.0.1 to 9.2.0.7 ???
Dear all, I've just upgraded my Oracle software to version 9.2.0.7 because it corrects a bug found in 9.2.0.1. OK, now the bug disappeared... but .... Now I cannot use anymore IMP and EXP. I face the following error : ------------8<------------------8<------------------ C:\Temp>exp ME/password(a)databas... 4 Oct 2005 13:05

concurrent access
When trying to execute select * from tablename from two differnt sql plus instances at the same time ( the same user ) both of sql plus stop working and don't get any response until i restart the sql plus. Why ? sk ... 14 Oct 2005 03:37

ORA 2049 error
A process runs on a split database environment - connecting locally to the database db1 and remotely to the database db2 (via database links). It deletes a bunch of rows in a table A in database db1 for a specific account and updates another table B in the database db2 for the same account. The access to table ... 28 Sep 2005 18:37

Before Insert Trigger
I have a table test. I have set up a trigger (before insert) CREATE OR REPLACE TRIGGER tr_test_row BEFORE INSERT ON test FOR EACH ROW There is a primary key on table test on name column. There is already a row in test table. When I insert a row with same name as an existing row, Oracle does not fire t... 28 Sep 2005 18:37

default port for EM
Hi all, I installed 10.2 on Win2003. I want to open Enterprice Manager, but don't know how. What do I enter in : http://<host_name>:5500/em (<- example)??? Thanks, Eugene ... 23 Sep 2005 17:09

10gR2 dbms_scheduler No process is on the other end of the pipe (winxp)
Hi, a little problem - trying to - using dbms_scheduler on windows XP. Who has a clue apart from the lack of a decent operating system ? ;-) db version is 10.2.0.1 SQL> begin 2 dbms_scheduler.create_job('t1', 3 job_action=>'C:\WINDOWS\SYSTEM32\CMD.EXE', 4 number_of_arguments=>3, 5 job_type=>'execut... 25 Sep 2005 15:54

ora: 1033 : Oracle intialization or shutdown in progress
i am using oracle 10g and i could not sign in using sql plus ,it gives the error ora:1033 (oracle initialization or shutdown in progress). At least i know what causes this error. As suggested by different people i waited for more than 3 hours but did not get it right. I tried using 10g enterprise url... at least ... 22 Sep 2005 10:12