dbTalk Databases Forums  

Sponsored Links


comp.databases.oracle comp.databases.oracle


Discuss in the comp.databases.oracle forum.



Post New Thread
Threads in Forum : comp.databases.oracle Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
Hello All. Currently we are porting some software from NSK (HP Hon-Stop) SQL to Oracle and I faced with the following problem... The SQL...
Dmitry Bond.
09-16-2004 05:58 AM
Dmitry Bond. Go to last post
2 176
Hello, I want to create a generic script that connects to Oracle databases (from 7.3.4 to 9.2 version) with a guest user. This script should return...
F. Biguet
09-16-2004 04:41 AM
F. Biguet Go to last post
5 171
How do I grant all privileges for a schema that has a large number of existing tables, procedures, functions, etc to a newly created role, without...
Ted
09-15-2004 08:41 PM
Bob Murphy Go to last post
2 158
#####Background 1) CRONJOB runs 2 RMAN shell scripts at 3AM backup_begin.sh- export and rman backups report_begin.sh- list rman reports My...
TX-DBA
09-15-2004 11:16 AM
TX-DBA Go to last post
0 170
assume: user a has the table tab_a user b has select-right on the table tab_a an creates the view view_b create view view_b as select * from...
matthias
09-15-2004 10:45 AM
matthias Go to last post
2 261
I guess this is an architecture question. The question is: If I've got two (or more) Oracle databases, when does it make sense to integrate them...
puppet_sock@hotmail.com
09-15-2004 09:50 AM
Yukonkid Go to last post
1 159
No flame wars, please! We're planning a move from a non-relational system to a relational system. Our choices have been narrowed to Oracle and DB2....
Mike
09-14-2004 10:51 PM
Michael D. Long Go to last post
38 645
Federal Government client requires an Oracle 11i specialist for a long-term assignment. Are you and 11i expert (including Purchasing,...
The AIM Group
09-14-2004 04:11 PM
The AIM Group Go to last post
0 241
Hi I am attempting to build a firewire based shared disk subsystem for Oracle RAC 10g. I was wondering if anyone new which chipsets were on the...
bjl
09-14-2004 11:33 AM
bjl Go to last post
0 227
Hello there! I am trying to read from a text file and load a table in ORACLE8i. For example I have the following...
Demetris
09-14-2004 05:19 AM
craig Go to last post
1 169
How do I update the views user_tab_columns and dba_tab_columns? I am using Oracle 9. I am trying to use a select command to find out info about the...
Greg Bailey
09-14-2004 04:32 AM
Greg Bailey Go to last post
4 182
Hi Folks, how to identify 2 different session on same machine, same/nearly same logon time that is running on a oracle server. We have different...
Kamesh
09-13-2004 07:24 PM
Joel Garry Go to last post
1 257
Hello all, I am working on creating an eul gateway for Discoverer. I have the sample scripts and was wondering if anyone has done this. I am...
LC
09-13-2004 07:08 PM
LC Go to last post
0 179
Hi, I need to create a table in Oracle DB using SQL before which I need to check if it exists or not, where the dbuser will have CONNECT...
google_user
09-13-2004 04:27 PM
Wario Go to last post
2 196
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 Go to last post
0 165
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 Go to last post
1 181
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 Go to last post
1 159
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 Go to last post
2 213
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 Go to last post
1 149
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 Go to last post
1 192
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 Go to last post
4 202
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 Go to last post
4 172
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 Go to last post
0 150
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 Go to last post
0 251
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 Go to last post
3 169
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 Go to last post
1 164
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 Go to last post
4 255
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 Go to last post
1 257
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 Go to last post
2 176
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 Go to last post
0 279
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 Go to last post
4 148
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 Go to last post
1 170
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 Go to last post
1 153
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 Go to last post
1 252
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 Go to last post
1 142
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 Go to last post
2 180
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 Go to last post
1 227
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 Go to last post
1 281
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 Go to last post
2 172
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 Go to last post
1 205
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 Go to last post
2 158
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 Go to last post
1 172
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 Go to last post
3 182
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 Go to last post
2 160
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 Go to last post
3 463
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 Go to last post
0 146
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 Go to last post
1 246
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 Go to last post
1 195
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 Go to last post
0 149
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 Go to last post
5 163
Post New Thread

Display Options
Showing threads 301 to 350 of 2012
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.