Oracle
in [SQL]
|
Before turning to oracle support.......component 'DBMS_SYS_SQL' must be declared 10gR2 on Windows 2000 All running absolutely fine. We develop applications using OHS / mod_plsql. Suddenly we got a "page not found" error in the browser trying to access a package.procedure via the browser. On looking at the OHS error log we see: [Thu Jul 03 14:19:58 2008] [error] [client 91.141.235.91]... 3 Jul 2008 12:30
problem deleting datafile Hello, I have a problem with a script that ran OK with 9i but which does not work with 10G Here is the output: SQL> @tmp Tablespace dropped. Tablespace created. Commit complete. DROP TABLESPACE getreports_TEMP INCLUDING CONTENTS AND DATAFILES * ERROR at line 1: ORA-00959: tablespace 'getreports_TEMP' does no... 5 Jul 2008 05:23
table getting analyzed automatically in oracle 10g I am facing a strange problem.... Every night, tables in my database are getting analyzed automatically. I have checked, our job is configure only for Sunday, not daily.. but it is happening daily It is becoming a problem now.... because batches become slow in night because of this. it is oracle 10g (10.2.0.2).... 4 Jul 2008 05:54
other than auditing, a way to see last execution time? 9.2.0.5 Is there a way to determine the last time a procedure was executed if auditing isn't turned on in a database? ... 2 Jul 2008 12:55
CREATE OR REPLACE VIEW ORA-01031 Hello, I am trying to run a long sql script that creates tables, triggers and procedures etc. I ran the same script on 9i some time ago and it worked OK - but 10G barfs on CREATE OR REPLACE VIEW as follows: DROP USER getreports CASCADE; CREATE USER getreports IDENTIFIED BY getreports DEFAULT TABLESPACE getr... 3 Jul 2008 10:26
New Instance for Existing Database -- 10gR2 under Win Server 2003 64-bit I'm a Unix/Linux Oracle developer who needs to ask a Windows-oriented DBA question. For testing purposes, one of the guys in this shop wants a new instance that will access existing database files. Working from home late at night, he copied all the files (control files, DBFs, and everything) and then blew away t... 2 Jul 2008 11:53
Urgent openings ...get a refund Don't waste ur time any more and get a refund, because of your spelling. -- Regards, Frank van Bortel ... 2 Jul 2008 10:51
using TFSSPUTL.SQL on Oracle 10 On the Oracle 10 DB: SHOW PARAMETER shared_pool_size; Is returning 0 because it is not set How to update script TFSSPUTL.SQL to get "Shared pool allocation (actual)" I tried replacing " select value into pool_size from v$parameter where name='shared_pool_size'; " with select sum(bytes) into pool_size from v$s... 3 Jul 2008 09:24
dropping a column in a production database Is this a safe operation? According to the docs, it should be. Any contraindications? (Oracle 10.2.0.3 on SUSE Linux) Thank you. Kind regards, Y. ... 7 Jul 2008 18:41
sqlldr question I have a table with 2 columns..... CREATE TABLE TEST ( ID NUMBER(5), NAME VARCHAR2(30)) My data file looks like the following and '|' is the col delimiter 10| | -- single space 20| | -- 5 spaces 30|\ | -- back slash followed by a single space 40|| ... 2 Jul 2008 08:48 |