Rating Thread / Thread Starter	Last Post	Replies	Views
Any recovery after Oracle exceeds disk limits under Linux? ( 1 2 ) Hi all, My co-worker's linux machine was importing a .dmp file and it exceeded the disk capacity (it was on auto-extend wit no limits), and now... deanbrown3d@yahoo.com	03-15-2005 03:08 AM steve	15	125
newbie: examples of regular expressions in oracle? I have clobs with html data. I want to remove two tags from this html. I think the best way to do it is via a regular expressions search... bbcrock@hotmail.com	03-14-2005 07:25 PM joel-garry@home.com	9	92
ORA-29531 Error - and the method is declared both PUBLIC and STATIC Could someone be of assistance and show me the problem with the following code? I have researched Metalink regarding ORA-29531, and the most common... jfk2001	03-14-2005 12:30 PM jfk2001	4	151
got timeout troubles after starting dbconsole Hello, I've installed Oracle 10g on my united linux machine. After some troubles (that can be solved by google) I'm now on the last step: Starting... Robert Meggle	03-14-2005 08:18 AM Robert Meggle	0	101
Re: Table key fields On Sun, 13 Mar 2005 20:15:23 +0100, Nicolas Prömper wrote: In Oracle's terminology this would be a constraint. Therefore you would want to look at... GreyBeard	03-13-2005 04:25 PM Sybrand Bakker	1	94
Multi Table View I am creating a multi-table view. Table1 joined to Table2 by ID field, it is a one to one match, also I want to join table3 to table1 by SALESID,... Mitchell	03-13-2005 12:11 PM Thierry PLASSART	1	98
Function that Iterates down a structure ( 1 2 ) Now that I am a beginner function generator I am trying to create a function that iterates down a structure. Struct table looks like this id par ... mike	03-13-2005 04:01 AM mike	13	160
Bad Function Can figure out why this function is bad. create or replace function get_desc ( field number ) return varchar2 as my_desc varchar2(50); begin select... mike	03-12-2005 07:20 PM mike	4	118
Migrate from 8.1.7 to 9.2 This was my first trial to migrate my 8.1.7 (patched with 8.1.7.4.1 ) to 9.2. I was following the Oracle 9.2 migration documentation, Chpater... cschang	03-12-2005 06:31 PM cschang	2	90
How can I tell if an application requires Enterprise Edition. I have a new client who have no in-house Oracle expertise. Their external software developer told them they needed Enterprise Edition, but I am... Jim Smith	03-12-2005 05:06 PM Andy Hassall	5	101
Avoid the fragmentation in 9.2 We have a database in 9.2.0.5. Recently, we set up a procedure that will load about 1.5 millions records into a tmp table, drop a old table rename... cschang	03-12-2005 07:42 AM Frank van Bortel	8	88
PGP Encryption in PL/SQL Hi, There is a UNIX CRON jobs written in PERL that 1. Runs a query. 2. PGP encrypts the output 3. and sends it out via email. We want to move this... sameergn@gmail.com	03-11-2005 07:39 PM Malcolm Dew-Jones	7	117
Query Question ( 1 2 ) I have a table defined like: CREATE TABLE ORGS ( NUM INTEGER NOT NULL, ID INTEGER NOT NULL ) In the table I have like: mike	03-11-2005 05:24 PM Andy Hassall	11	147
SQL-Loader - searching for Strings Hi, I've got a problem while loading data with the SQL-Loader; consider the following CTL: *********************************** LOAD DATA infile... andreas.krisor@gmx.net	03-11-2005 12:21 PM andreas.krisor@gmx.net	0	110
foreign key question Hi this is a general question about relational databases, not specific to Oracle (I think), so if there is a better place to ask then please let... Peter Kirk	03-11-2005 10:32 AM DA Morgan	2	81
Default base Hi, On first Oracle install, what's the default base to test connect with JDBC please ? Thanks, Jean-Luc M. -- Jean-Luc M.	03-11-2005 09:36 AM GreyBeard	1	101
Is it possible to refresh a Materialized view on demand ? Hi all! I've created a Materialized view with this options: CREATE MATERIALIZED VIEW MVW_LINKS REFRESH FORCE ON DEMAND WITH ROWID START WITH... fmarchioni@libero.it	03-11-2005 03:07 AM fmarchioni@libero.it	2	91
Extproc & shared server mode Hi, All! I ask for your help in such situation: I have Oracle 9.2 and a package with external procedures on C. Procedures from external DLL don't... Dmitry Pavlov	03-11-2005 02:26 AM Dmitry Pavlov	6	136
cannot uninstall and reinstall oracle 10g I installed Oracle 10g database before, but it had missing files error. Therefore, I tried to uninstall and reinstall again. I ran the installer... jrefactors@hotmail.com	03-11-2005 12:26 AM DA Morgan	5	135
RMAN: restoring backup files from one machine to another Hi all, Currently I'm trying to restore a backup file created by an oracle instance on my production server to another machine. I've moved... larry9700	03-10-2005 11:56 PM Sybrand Bakker	1	122
additional condition of update in merge I tried to learn the merge, so i tried this in a procedure however, it gave me an error MERGE INTO ORDER_STATUS_NOTIFICATION o1 USING ( SELECT... cschang	03-10-2005 10:56 PM Malcolm Dew-Jones	7	130
Can I use an alias name is a where clause ( 1 2 ) The following select statement yeilds an error message ORA-00904: "Total": invalid identifier. select t.a + t.b + t.c Total from some_table... Lig	03-10-2005 10:28 PM DA Morgan	12	286
RMAN - Recovery from different location Hi all, I'm trying to do some tests with rman for backing up and restoring my database. I just can't find how I can indicate that my backup file of... Kristof Coucke	03-10-2005 02:28 PM Kristof Coucke	2	101
DB Creation problem Sys: RHES 3.0 x86 200GB HD, 512MB Ram During install when running dbcr, error that we lost connection. Connection to what? Any area that need... Hal Davison	03-10-2005 08:16 AM xman	2	90
User priviliges I am searching for the possibility to find out, what kind ov user rights the current user has. Detecting the roles are easy... Nicolas Bronke	03-10-2005 07:02 AM Nicolas Bronke	2	82
looking for a good Database/oracle book for beginner hi can someone help me, i'm looking for a good beginner book, i have no experience with database program. thank you Rony Yeo	03-09-2005 05:14 PM DA Morgan	3	82
How can I get information about name columns returned in ref cursor type ??? Hi, I have some problem. Some PL/SQL procedure return parameter which is a ref cursor type. Can I get information about column names returned in... Maciek	03-09-2005 05:12 PM DA Morgan	1	104
PL/SQL Query problems. Hi, Trying to get all the tables with the field 'TLAST_CHANGED_UID, then using that list get the number of records in each table where the field... Craig & Co.	03-09-2005 03:49 PM Craig & Co.	6	149
What's a good Oracle & SQL Book? Looking for a good Oracle and SQL book. I've been working as a programmer for 8 years and have done some oracle programming using ADO, more general... deanbrown3d@yahoo.com	03-09-2005 01:47 PM GreyBeard	6	102
Importing from 10g to 9? Hi there, We've had problems importing from 10g databases to 9. Is there some trick that we can do to allow this to occur smoothly?... deanbrown3d@yahoo.com	03-09-2005 09:54 AM deanbrown3d@yahoo.com	5	111
SQLLoader question I want to use sqlloader in order to load a text file data into the database. The file may contain one different types of records (one of the... Golan	03-09-2005 09:37 AM GreyBeard	2	84
Standby database only available on Enterprise Edition? Looking at the Database edition comparison chart, I see DataGuard is only available as part of Enterprise Edition. Does this mean that standby... Jim Smith	03-09-2005 07:21 AM Marcel Meijn via DBMonster.com	1	90
checking Oracle version How can I check Oracle version? If I execute procedure with 'select version from v$instance' I get error that 'table or view not exists' because I'm... Jarek	03-09-2005 03:02 AM Jarek	5	110
ORA-03113 & 3114 after select Hello, I tried to include another join in this select (see the full outer join on a view), and i got an ORA-03113 error followed by a ORA-03114. so... Andreas Vandenberghe	03-09-2005 01:19 AM Bobiander	1	174
oracle sql query - output one line? hi, Below is the output required, how ? Total 1980 1981 1982 1983 20 1 3 5 2 SQL written below gives output as captain_2010@yahoo.com	03-09-2005 12:31 AM DA Morgan	6	76
external procedure and gcc (newbie) Folks, Has anyone ever sucessfully compiled an external procedure for Oracle 9i on Solaris using gcc? I attempted to follow the documentation... Matt	03-08-2005 10:27 PM Matt	0	104
A bit of levity So if you want to bash me for being off topic have at it but I thought this worth sharing. But at least it is in c.d.o. marketplace and isn't... DA Morgan	03-08-2005 07:47 PM joel-garry@home.com	5	98
Need to write trigger for "adding a new table" But I can't add a trigger to ALL_TABLES because its a view. What to do? I need to create an update-log table for our database, to write... deanbrown3d@yahoo.com	03-08-2005 12:27 PM deanbrown3d@yahoo.com	7	105
Corrupt data Am using Powerbuilder 10.0.1 on WINXP with Oracle9i. Have just migrated an application for home use(non-network) from SQL Server to Oracle9i. Am... William F. O'Neill	03-08-2005 10:04 AM Ed Prochak	1	108
Out of temp space I would appreciate some help understanding how Oracle 8i uses Temp space for queries. I have been working with a rather simple query, joining two... Randy Harris	03-08-2005 09:59 AM DA Morgan	6	101
Question regarding query Hi All, I was reading on some of the Oracle analytical functions. I was playing with this query: SELECT deptno, ename,... amerar@iwc.net	03-08-2005 08:58 AM Frank van Bortel	1	90
Hardware requirment Can I install 10g linux version on a P200 MMX system ? Alan	03-08-2005 06:45 AM GreyBeard	4	96
In Clause selecting in reverse order, wonder why? Hi, I am running a query using an "in clause" in the condition. When no order clause is given, the query selects the rows in the reverse order in... Deepesh Garg	03-07-2005 05:08 PM deepesh.g@gmail.com	4	87
Question regarding query Hey All, I was browsing and reading on some of the analytical functions within Oracle. I came across this example: SELECT deptno, ename,... amerar@iwc.net	03-07-2005 03:51 PM amerar@iwc.net	0	74
BIG Outer join problem Hi All, You will hate me after looking at the query below. But, if you look at the query, there is a section (actually in 2 places) where I... amerar@iwc.net	03-07-2005 01:44 PM Turkbear	4	104
DIRECTORIES and BFILE problems Hi all! I'm having a problem in creating BFILEs in a DB directory. In my Java program I do these simple steps. 1. Create a directory: CREATE OR... JavaDeveloper	03-07-2005 10:41 AM Carlos	8	181
SYSDBA on Oracle 8.0.5 Hi, i'm in trouble with Oracle 8.0.5 on NT4 Server SP6a I'm trying to connect as SYSDBA with SYSTEM or with SYS on the Instance Manager. The... Sitta Davide	03-07-2005 09:55 AM GreyBeard	3	84
oracle, hotbackup and splitmittor Dear group, I would like to know how I can use oracle hotbackup mode and guarantee that all data has been flushed from memory onto disk before I... Paresh Chudasma	03-07-2005 09:44 AM rsavela@gmail.com	1	91
in which sys-view are unique-constraints Hello Does anyone know in which sys view I can find which columns have unique constraints? Because all_constraints has only constraint_type which is... Lore Leuneog	03-07-2005 08:38 AM Turkbear	5	120
ABUSE Do not post jobs in this group. Your company is constantly breaking the rules. Tom Gugger	03-07-2005 07:33 AM Tom Gugger	0	123

Page 109 of 176

109

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