Oracle

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

Verify driving_site hint
Is there some easy way to verify if the driving_site hint in a SQL query is obeyed and executed at the specified location? Maybe by adding something to query like select /*+driving_site(remote_table) */ $execution_site_name, ... Thanks ... 2 Jul 2008 10:51

Error Compiling Java in Oracle 10g
I can compile the following Java code just fine when using the Java compiler. But I am getting an error when trying to compile the source file in Oracle. Here is the code: create or replace and compile java source named host as import java.io.* ; import java.sql.* ; public class Host { public static fina... 2 Jul 2008 17:03

Transportable tablespace
Hi, In 8i there was a limitation with FBI and TTS Is this limitation stay there for 9i, 10g ? Thanks for your lights ... 2 Jul 2008 10:51

Slow query
Hi, Is it possible to speed up this query ? Thanks in advance 9.2.0.6 2 SELECT dc0.nrid, dc0.so0_nrid, dc0.etat, 3 TO_CHAR (dc0.date_creat, 'DD/MM/YYYY') "dc0.date_creat", 4 w.remark "Modif Groupement", y.remark "Ecart Coop", 5 u.remark "Nom Pr�commande", z.remark "Am... 2 Jul 2008 11:53