Sponsored Links

comp.databases.oracle.misc comp.databases.oracle.misc

Page 13 of 176

« First

113

Last »

Threads in Forum : comp.databases.oracle.misc

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
Using vaarray in dynamic sql - ORA-00904: invalid identifier All, I am doing the following work in oracle 10.2.0.1 The procedure below is producing the error "ORA-00904: "NTT": invalid identifier" Note that... Kevin S	01-27-2009 10:08 AM Kevin S	2	88
*2009 Salford Data Mining Conference - San Diego, CA* Salford Systems' Data Mining Conference 2009 San Diego, California Conference Dates: August 23-25, 2009 Post-Conference Training: August 26-28,... Aaron Adams	01-26-2009 02:15 PM Aaron Adams	0	63
Linked table Doesn't show data I'm working in a database Oracle 10.2.0.4.0 where there is created a link to a second database Oracle 8.1.6.0.0. There is a synonym created... CenturionX	01-22-2009 11:58 AM gazzag	4	113
ISO Week of Year Hi all, Oracle 10.2.0.3 on Linux ... I'm having difficulty with a proc which tries to compare data across years at a specific point in time. For a... Geoff Muldoon	01-21-2009 05:19 PM Geoff Muldoon	4	128
How to thanks for your beloved ? Take the chance of the Valenitne’s Day to show your love, appreciation, and humor for your love, family, and friends: “Clone” your lover to surprise... maky	01-20-2009 03:35 AM maky	0	104
renumbering the data in a column? I have some rows that I would like to renumber. For example: select * from t where name like 'x%' order by seq; seq name --- ---- 15 ... mh@pixar.com	01-19-2009 04:58 PM Robert Klemme	8	126
use copy command with error ORA--4192986 dear all, I'm try to make copy from other database to local database by copy command but I got error as the following: SQL> copy from... NOVA	01-19-2009 07:49 AM NOVA	2	122
Snapshot log problem Hello, Recently we migrated an Oracle database from version “8.1.6.0.0” to “10.2.0.4.0”. This database is replicated. This replication is performed... CenturionX	01-16-2009 01:52 PM ddf	3	206
diskgroup calculations Hi I am using this query to display the size of the diskgroups in Oracle and manually adding the figures up to get the total size of... just_real	01-16-2009 01:02 PM Mark D Powell	1	209
best way to simulate a lost connection? This for RAC 10gR2. I would like to test my client-side application code that deals with catching and reporting a lost or broken connection to the... mh@pixar.com	01-15-2009 05:47 PM S R	9	84
Gropus I need to do something really weird with some numbers. I need to seperate them into quintiles. Say for example I have these... mrdjmagnet@aol.com	01-09-2009 01:53 PM Michel Cadot	5	111
Dynamic SQL Hi, We're rewriting a lot of code in order to increase our hit count in the library cache. One thing we are running into is where dynamic table... mrdjmagnet@aol.com	01-06-2009 04:42 PM Mark D Powell	5	135
Oracle E-Business Suite Question - Users I am new to oracle. I have an Oracle Ebusiness Server 12i?, running on 10G, running in a redhat environment. My question is about users. Will I... sysmin	01-06-2009 09:48 AM sysmin	0	102
Certifications in Oracle Applications Hello, Greetings from iWare Logic !!! We are Oracle Approved Education Center which provide Trainings & Certifications in Oracle Applications in... amit.giri@iwarelogic.com	01-05-2009 04:43 PM joel garry	2	82
SGA / Latch Question ( 1 2 ) Hi, This just seems weird. I look at our SPFILE: *.shared_pool_size=2G I query v$parameter: 1073741824 I ran a query: SHARED_POOL_USED... mrdjmagnet@aol.com	12-31-2008 11:02 AM Mark D Powell	16	309
Re: Error 3146 - ODBC Call failed Niranjan <nhiras (AT) gmail (DOT) com> wrote: Easy, just use Oracle instead. You have come to the right group! Yours, Laurenz Albe Laurenz Albe	12-31-2008 10:56 AM Mark D Powell	8	210
Question on SGA Hi, This just seems weird. I look at our SPFILE: *.shared_pool_size=2G I query v$parameter: 1073741824 I ran a query: SHARED_POOL_USED... mrdjmagnet@aol.com	12-30-2008 01:10 PM mrdjmagnet@aol.com	0	97
get the sid,serial# of my connection? ( 1 2 3 4 5 ) How can I programmatically get the SID and SERIAL# for my connection from a client side program? Many tia! Mark -- Mark Harrison Pixar Animation... mh@pixar.com	12-29-2008 07:26 PM joel garry	40	403
restore ( 1 2 3 ) my c drive with OS failed, oracle database was installed on drive d. how i can restore database from existing oraclexe directory? tnx croora	12-24-2008 08:39 AM ddf	20	260
Privileges issue Hello everybody, I’m having trouble trying to run a procedure. I have a query that retrieves information from a table X. I run the query and it... CenturionX	12-23-2008 09:03 AM CenturionX	8	212
A join query Hi everybody, I need i query that i will run behind VB, this query will take a value from a text box, and look it in the ACCESS DB provided, This is... Totti	12-18-2008 04:30 PM Shakespeare	8	84
ORA-27369: job of type EXECUTABLE failed with exit code: Permissiondenied ( 1 2 3 4 ) Hi I was trying to set up a test job in Enterprise manager and I got this error when it tried running the script. I've created the script on a RAC... just_real	12-17-2008 05:05 PM joel garry	36	442
DataArchitect 4.1 for Oracle on LINUX/SOLARIS/WINDOWS/MAC OS/HPUX Rancho Santa Margarita, CA -- 16 December 2008 -- theKompany.com, producers and distributors of high-quality open source and commercial Linux... smga3000	12-16-2008 03:52 PM joel garry	4	72
Oracle Functional/ Sales Contract Module/ Contract TOM GUGGER INDEPENDENT RECRUITER tgugger (AT) bex (DOT) net 419-537-9447 Oracle Functional/ E-business/ Contract/ Ohio We currently have a three... Tom Gugger	12-16-2008 11:54 AM Tom Gugger	0	58
Dynamic SQL to call a function with RETURN value? ( 1 2 3 ) Hi Please can someone help me out. I have done quite a bit of searching and 'trial and error' without much success. I have simplified the problem... mwmann	12-15-2008 05:32 PM joel garry	28	368
What is PL/SQL ? ( 1 2 ) What is PL/SQL ? http://interviewdoor.com/questions-faqs/viewtopic.php?f=152&t=1041 naga	12-15-2008 03:11 PM Ed Prochak	16	146
Getting ORA-27369: job of type EXECUTABLE failed with exit code:Permission denied Hi I was trying to set up a test job in Enterprise manager and I got this error when it tried running the script. I've created the script on a RAC... just_real	12-14-2008 11:22 PM just_real	0	81
General question on tablespace creation ( 1 2 ) Hi, I have a general question about tablespace creation. Is it better to create a small tablespace auto-extendable to a (defined) maxsize or to... Xavier Maillard	12-14-2008 04:56 PM Michael Austin	12	85
complex SQL ? ( 1 2 ) SQL question If I have a table like that ID \| ESTIMATED_VAL \| REAL_VAL xyz \| 100 \| 129 abc\| 110 \| 80 etc... Jazz	12-13-2008 02:29 PM Paul Linehan	12	144
What are two parts of package ? What are two parts of package ? http://interviewdoor.com/questions-faqs/viewtopic.php?f=152&t=1063 reema	12-12-2008 03:00 PM DA Morgan	8	70
Aplication Server 10g and java Memory problem Hello! Problem : 08/12/12 11:51:22 Exception in thread "Timer-4" java.lang.OutOfMemoryError: Java heap space WHAT I HEEEL I GOING ONE??? I have... hehehehe	12-12-2008 09:24 AM Laurenz Albe	4	68
NULL values in IN condition ( 1 2 3 ) I want to obtain all the possible values of a VARCHAR2(1) column named FOO, sort them (either ASC or DESC) and finally fetch to two top-most rows.... Álvaro G. Vicario	12-12-2008 07:35 AM Álvaro G. Vicario	24	163
What are the cursor attributes used in PL/SQL ? What are the cursor attributes used in PL/SQL ? http://interviewdoor.com/questions-faqs/viewtopic.php?f=152&t=1049 raj	12-12-2008 05:50 AM raj	0	52
What will happen after commit statement ? What will happen after commit statement ? http://interviewdoor.com/questions-faqs/viewtopic.php?f=152&t=1051 raj	12-12-2008 05:45 AM raj	0	49
What will happen after commit statement ? What will happen after commit statement ? http://interviewdoor.com/questions-faqs/viewtopic.php?f=152&t=1051 geninuesolutions606@gmail.com	12-12-2008 05:13 AM geninuesolutions606@gmail.com	0	48
What is an Exception ? What are types of Exception ? What is an Exception ? What are types of Exception ? http://interviewdoor.com/questions-faqs/viewtopic.php?f=152&t=1052 geninuesolutions606@gmail.com	12-12-2008 05:12 AM geninuesolutions606@gmail.com	0	151
What is Overloading of procedures ? What is Overloading of procedures ? http://interviewdoor.com/questions-faqs/viewtopic.php?f=152&t=1062 reema	12-12-2008 04:08 AM reema	0	66
get sequence number for a row just inserted? What's the most canonical way get the autoincremented sequence number of a row I just inserted? -- Mark Harrison Pixar Animation Studios mh@pixar.com	12-11-2008 08:17 PM DA Morgan	8	74
Trying to export to a text file using PL/SQL Hi I have the following query and I need the output to be in the form of an attachment (text or csv) instead of being in the body of the email. I am... sajrizvi80@gmail.com	12-11-2008 09:20 AM sajrizvi80@gmail.com	0	63
Weird listbox issue (Gupta(SqlWindows), Oracle) ( 1 2 3 4 ) A weird problem has occured, maybe someone could give any advice? Client has 2 Oracle 10g databases - test and real. Gupta application used with... MVk - Monika V. kycka	12-05-2008 01:16 PM joel garry	32	296
Oracle Purchasing Receipting Our Oracle set up has a bespoke module for generating accruals and works certificates (which then generate invoices). We recently swapped over to... Math	12-05-2008 09:42 AM Math	8	53
Money Data ( 1 2 ) Hi , I'm in the process of migrating a SQLServer database to Oracle. This is the first Oracle database I've been involved with and I'm aware that... Laurence	12-03-2008 06:57 PM s2cuts	16	121
Remove everything from a schema ( 1 2 3 4 5 ) I want to remove all the contents of a schema (tables, indexes, sequences...) in my development box so I can checkout a fresh working copy of the web... Álvaro G. Vicario	12-01-2008 08:28 PM joel garry	44	345
RMAN Clone NOARCHIVELOG I am using Oracle 10.2.0.4 with RMAN to clone a database from an RMAN cold database backup. Both databases are in noarchivelog. I am using an Rman... PLAITER	11-28-2008 07:24 AM PLAITER	0	67
Tool for CSV dump? ( 1 2 3 ) Hi experts, are there tools to make a fast dump of complete databases to CSV? Without needing any additional licenses from Oracle...? TIA Tellie Tellie	11-27-2008 06:10 AM steph	28	173
JOINs against a subquery ( 1 2 ) I have a pretty complicate query that produces a sales summary, something similar to this: customer_id sales_amount =========== ============ 1 ... Álvaro G. Vicario	11-27-2008 04:08 AM Álvaro G. Vicario	16	100
usage of a calculated index Hello, I've created the following table and view: _____ CREATE TABLE X_EF ( ID_EF INTEGER NOT NULL, A_VALUE VARCHAR2(1) NOT NULL, A_NUMBER... Norbert Winkler	11-25-2008 10:45 AM Norbert Winkler	0	171
Performance: SDO_RELATE vs. Stored Procedure ( 1 2 3 ) Hi, I'm relatively new to Oracle and as I am experiencing some inexplicable results I ask for your help. In Oracle 10g XE I created a datatype for... schaef2k@googlemail.com	11-23-2008 11:12 AM Shakespeare	28	239
Re: Migrating from Win2k3 to linux "Jan Lühr" <usenet (AT) stephan (DOT) homeunix.net> wrote export from the original and then do a full import in the target. (pre-create the... gym dot scuba dot kennedy at gmail	11-23-2008 10:53 AM Vladimir M. Zakharychev	4	157
Regarding "how can i trap the empty explicit cursor value" ( 1 2 3 ) Hi, i write a explicit cursor but for the some condition data not available for that cursor. at that time how can i trap the NULL value for the... Prady The fire	11-22-2008 12:24 PM Robert Klemme	20	291

Page 13 of 176

« First

113

Last »

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	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