Oracle
in [SQL]
|
Exec statement I am trying to use an exec statement to run a script on Dbvisualizer. However, I get this error exec test1.sql 11:27:53 [EXEC - 0 row(s), 0.000 secs] [Error Code: 900, SQL State: 42000] ORA-00900: invalid SQL statement .... 1 statement(s) executed, 0 row(s) affected, execution time 0.000 sec I'm sure t... 7 Sep 2005 18:06
Oracle 8 on Windows XP Hi All, I've installed the Oracle 8 (Server) for Windows NT on Windows XP Pro and I get an information that the Strtdb80.exe encountered a problem and will be closed. Is there any patch or anything else that would let me use the Oracle on WindowsXP? Regards User ... 5 Sep 2005 16:31
After Creating SPFILE from PFILE startup gives ora-03113 Saw a doc on Metalink that said all you had to do was reconnect and restart the instace if an error occured after creating an spfile from a pfile. I checked metalink for all deprecated parameters for 9.2.0.6 and I dont have any parameters listed that are deprecated. Anybody know. Below is my parameter file. ... 6 Sep 2005 13:05
calling SQLLDR from C# (ASP.NET) Hi, I'm trying to call SQLLDR from ASP.NET (C#) to load data from a text file into a table. I'm not a windows/microsoft person so if you could give me a hint I'd appreciate it. I have tried a few ways to call sqlldr but it looks like the line with sqlldr command is just not being executed... There are no errors... 2 Sep 2005 14:48
SGA configuration Hi, I inherited a 9.2.0.4 database on a W2000 / 4GB box: The spfile is like below: SGA_MAX_SIZE=950M Cache = 167M Shared Pool= 250M Log Buffer = 0.5M Large Pool = 130 M Java Pool = 130 M At a first glance, it seems to me that Shared pool is too big and Cache is too small, am I correct ?? I can kee... 2 Sep 2005 19:07
iSQL*Plus Problem - ORA-12162: TNS:net service name is incorrectly specified I seem to be able to connect locally using `sqlplus lee/$password(a)lee3` using SQL*Plus, but I get the following error when I use iSQL*Plus: ORA-12162: TNS:net service name is incorrectly specified I've seen plenty of similar posts on Google, but none of them have shed any light on the matter. My TNSNAME and ... 31 Aug 2005 19:51
Archive Processes Is there a way to define diffrent archive processes for primary and standby databases.I am asking this because most of the time our production db gets stuck as its not completed archiving as the archive processes are busy writing to the standby. ... 5 Sep 2005 02:39
ORA-28547 error with OCILogon Hello out there, I am using Oracle 10.0 OCI calling interface. When running the example of the bulk loading, I come across an Oracle error ORA-28547. I have incorporated the sqlnet.ora, tnsnames.ora and listener.ora below. What am I doing wrong? Or is this a new bug? Kindest Regards. =================... 30 Aug 2005 05:50
DBMS_RULE and using implicit variables - getting ORA-30625: method dispatch on NULL SELF argument is disallowed I've been looking at the DBMS_RULES demo from http://www.oracle-doku.de/oracle_10g_documentation/server.101/b10727/rule sdem.htm#1109503 . The script seems to work fine! It is able to refer to a value added through the use of 'add_pair'. However, when I try to encapsulate the script into a package ("rules") a... 24 Jul 2005 09:02
ora-01031:insufficient privileges. I defined a cursor for selecting V$LOGMNR_CONTENTS. And do the following action: fetch cur BULK COLLECT into collect1,collect2,.... limit 5000 When it is run in oracle9i, it is ok. But,it is run in oracle 10g,there is a error: ora-01031:insufficient privileges. I check the user's privileges, it is same in 1... 21 Jul 2005 22:00 |