Metalink says that, whenever we migrate from dictionary managed to locally managed tablespaces, 'Migrated tablespaces are not subject to the...

Shailesh

09-13-2004 05:07 AM
Shailesh

Hello, I want to install Oracle Repository. I created tablespace for repository, grant required privileges. During the installation it says...

Timur

09-13-2004 04:12 AM
sybrandb@yahoo.com

hi all, I want to know .. I read about IOT's in ORACLE Docs .. But Still I am confused .. when one should use IOT tables .. Thanks, Js

Js

09-12-2004 09:29 PM
Jim Kennedy

Have just upgraded my home installation of Oracle 10g. Was using 9i. The installation seemed to go fine, but with all the documentation, I'm having...

William F. O'Neill

09-12-2004 07:55 PM
Pedro Lopes

I've just got a copy of Red Hat Professional Workstation. I know that the 10G database is not certified on this version. My question is can I...

nimonic

09-12-2004 06:22 PM
Js

Hi all: I want to audit a truncate command on just three tables in a database. I have been reading ORacle manuals and books, but I can't see how to...

xanuda

09-12-2004 05:47 PM
Js

Hi, for an OnlinerReorg (SAP/ORACLE) i have to know the name of the tables without primary key. Where can i find it with sqlplus or...

Michael Maier

09-10-2004 07:10 PM
Pablo R

Hi, I'm in need of some SQL help regarding selection information from an Oracle user account that only has "SELECT_CATALOG_ROLE' granted to a schema...

Kevin

09-10-2004 09:30 AM
Wario

Hello, I want to set up some USER DEFINED METRICS in 10g. The restriction with USER DEFINED METRICS, is the query (or function ) monitoring...

Shailesh

09-10-2004 02:36 AM
Shailesh

Hello, I want to set up some USER DEFINED METRICS in 10g. The restriction with USER DEFINED METRICS, is the query (or function ) monitoring...

Shailesh

09-10-2004 01:53 AM
Shailesh

Have been using a db in Oracle 9i for sometime and now want to upgrade this db to Oracle 10g. Can someone point me in the right direction?

William F. O'Neill

09-10-2004 12:46 AM
Hans Forbrich

I'm trying to connect to an Oracle db on our network, through either SQL Server 2000 or Access 2000. Do I have to have Oracle client software loaded...

Dave

09-09-2004 09:00 PM
Jim Kennedy

We are currently searching for a reporting tool with graphics for our end users who are using Oracle's standard edition. We are not using the...

NBURGAN

09-09-2004 03:18 PM
Sonny Suri

Dear all, Server machine running Oracle Database Server on Linux and a Client machine running Oracle Client on WIndows XP. HOw it is possible to...

Miori

09-09-2004 12:01 AM
Christine

I have just upgraded my Oracle db from 9i to 10g. Of course, the installation did not go straightforward. Does 10g use a TNSNAMES.ora &...

William F. O'Neill

09-08-2004 07:49 PM
William F. O'Neill

dave (AT) skillbuilders (DOT) com (Dave Anderson) wrote in news:a0dc4048.0409070851.72c30c39 (AT) posting (DOT) google.com: IIRC,...

Ana C. Dent

09-07-2004 09:28 PM
Ana C. Dent

I need to reorder the primary key of a table. Say, Primary Key (field1, field2) changed to: Primary Key (field2, field1) Would like to know if...

t53864

09-06-2004 10:34 PM
Christine

Hello, I have a little problem with an oracle import. My problem is : 1) I have a dump (file.dmp) contains a table T1 (just for this example) 2) I...

M Bouloussa

09-06-2004 01:05 PM
Ana C. Dent

Anyone have any idea how to get the installer up and running. I have had 10G installed on this box before. We scrapped the box, recreated it, and now...

Sag!

09-06-2004 10:35 AM
Hans Forbrich

Here's what I was doing, it is obviously stupid because i have exceeded the "too many fields defined error" I have to create a database driven...

Johnson

09-06-2004 07:12 AM
Mark C. Stock

Does anyone has a script which starts all the required processes for 10g AS? It should start iAS db, infrastructure, AS etc.

Sandeep Nair

09-05-2004 06:30 PM
Ana C. Dent

Hi, I've installed Oracle 8i enterprise edition on P-III box which has XP pro(SP1), after installation it worked fine and after I rebotted my box...

ANSWER

09-05-2004 01:42 PM
Hans Forbrich

Hi, I have a table t1 with a long raw column, and I need to create a view v1 with a long raw column being a function ff1 of the long raw column in...

Lisa Tang

09-05-2004 10:36 AM
Hans Forbrich

Hi, Could you help me in this regard. I have to implement a Java Tree in the D2K Forms 6i. Can you suggest how to implement it and it will be much...

Thinvra

09-03-2004 10:11 PM
Ana C. Dent

Mark, Take a look at "SQL for Analysis" chapter 17 in Oracle8i Data Warehousing Guide (CUBE and ROLLUP). Regards, Rob "Mark Anthony" <mdejesus...

rob

09-03-2004 09:21 AM
Mark D Powell

I am having a problem linking an oci 7 application with oracle9i on AIX 4.3. The makefile has the following line: -L/home/oracle/product/9.0.1/lib...

Hesam Shamshiri

09-03-2004 05:30 AM
Frank van Bortel

Hi everyone. I am having a big performance issue with my ASP application with Oracle database. The application itself is a very database-generic...

Seung Y. Kim

09-03-2004 01:13 AM
Pratap

Could anyone tell me what this query means? Thanks a lot. --------------------------------------- select username from dba_users where not exists...

LittleDBA

09-02-2004 09:25 PM
Ana C. Dent

I need to create a ResultSet in an Oracle Java Stored Procedure and return it to a PL/SQL caller. I've done quite a bit of research in Oracle's...

Jim Garrison

09-02-2004 03:10 PM
Jim Garrison

I suggest you add an inline view - ( SELECT p.pub_nm, b.ean_no FROM publisher p, book b WHERE p.pub_id=b.pub_id ) publisher Then outer join...

Pratap

09-02-2004 12:02 AM
Pratap

hi, getting the following error when running the script below. it seems to me that the cursor is retrieving more then one value each loop. any idea...

Doron

09-01-2004 05:51 PM
Doron

Hi, I have installed Oracle 8i enterprise on local machine so I can learn SQL language and Oracle. Also I'm using DOAD from Quest Software v...

ANSWER

09-01-2004 01:51 PM
ANSWER

Hi, I just want to know if i can use INTERGRATE oracle FORMS, REPORTS with version control software specificaly CVS,Clearcase, Sourcesafe, PVCS. Has...

johnny

08-31-2004 09:27 PM
Ana C. Dent

I am in a crunch and need to covert this Oracle statement to MSSQL. Is there any Oracle/MSSQL experts out there that can help me? I do not understand...

Philip Mette

08-31-2004 06:11 PM
Bent Stigsen

Hi, I just want to know if i can use INTERGRATE oracle FORMS, REPORTS with version control software specificaly CVS,Clearcase, Sourcesafe, PVCS. Has...

johnny

08-31-2004 04:59 PM
johnny

i had a basic question on plsql, if i have a variable as varchar2, containing some text like 'A12345', how do i write a function to make sure that...

jmaxsherkimer

08-31-2004 03:52 PM
Alex Filonov

Hi All, We are planning to migration one of our Oracle 9i databases from HP-UX to AIX. What are our options? Upgrading our database to 10g in this...

Joseph Silverius

08-30-2004 04:47 PM
Dave

Has anyone ever heard of installing Oracle 9.2 on an Alpha OpenVMS box without using OUI? I know the Installation Guide says that ORACLEINS no...

Kevin McDaniel

08-30-2004 02:02 PM
Kevin McDaniel

Hi I'm writing a multi-threaded application and each thread has its own run-time context. My question is: 1. If a thread uses its context to open a...

pplppp

08-30-2004 11:24 AM
pplppp

A newby question: I've got a .dmp from from an Oracle database that I need to import into SQL Server. I have no idea how to do this. If anyone know...

ccc31807

08-30-2004 10:08 AM
cr_announce

Does anyone has the experience in using AIX 5.2-1 CIO feature with Oracle? Is this suitable for a read intensive database ?

Kenneth

08-30-2004 08:45 AM
Alpha

(Apologies for duplicating posts to *.misc and *.tools; Google wasn't co-operating .) Confio Software, a Boulder-based system performance tools...

Charlie Martin

08-27-2004 01:06 PM
Ed prochak

Billy: I like your answers in the groups. Especially something like this: Damn, don't you just love SQL! :-) I have yet to find a query that can not...

Alex Kizub

08-27-2004 12:58 PM
Alex Kizub

OMNI GROUP tgugger (AT) buckeye-express (DOT) com 419-380-8853 I’m looking for a technical J-Developer and Oracle Portal Consultant for a

Tom Gugger

08-27-2004 10:19 AM
Hans Forbrich

OMNI GROUP tgugger (AT) buckeye-express (DOT) com 419-380-8853 I’m looking for a technical J-Developer and Oracle Portal Consultant for a

Tom Gugger

08-27-2004 10:12 AM
Tom Gugger

OMNI GROUP tgugger (AT) buckeye-express (DOT) com 419-380-8853 I’m looking for a technical J-Developer and Oracle Portal Consultant for a

Tom Gugger

08-27-2004 10:04 AM
Tom Gugger

Hello, I am working with Oracle 9Ri2 version on Linux AS 2.1 for IA64. I have a problem when i try to lanch the following program : EXEC SQL...

Oracle 9Ri2 AS 2.1 IA 64

08-27-2004 09:30 AM
Wario

consider the following queries that deals with report pagination a ) select MYROWS.* from (select * from TABLE_NAME) MY_ROWS where rownum between 1...

Rishi Kumar

08-27-2004 06:33 AM
Romeo Olympia

Does anyone know why Oracle does not provide a package for really killing dbms jobs? I found that lots of people write about how it is done -...

Danes

08-26-2004 03:18 PM
Danes

Maybe I am just dizzy but I thought that 600 seconds is 10 minutes... Obviously not! Or maybe PL/SQL is just dizzy. SQL> declare 2 blah1 interval...

Danes

08-26-2004 03:10 PM
Danes