Rating Thread / Thread Starter	Last Post	Replies	Views
recomendations on a good book for learning oracle ? Hi All I'm new to oracle, I have learned SQL ,and played with MySQL, but I would like to understand and learn oracle, would anyone have any... Pat	04-23-2007 11:33 AM EdStevens	1	37
Install Problems With Oracle 10g & RHEL 4 Linux Recently I downloaded and tried to install 10g Standard Edition on RHEL 4 (64bit). Everything went fine except for errors in creating Oracle Net... Jack	04-23-2007 10:31 AM DA Morgan	1	42
Error when starting DBCA Hallo zusammen, ich bekomme folgende Fehlermeldung, wenn ich versuche den DBCA aufzurufen: Exception in thread "main"... daniel.kehrer@gmail.com	04-23-2007 09:14 AM daniel.kehrer@gmail.com	0	50
dbms_metadata set_remap_param tablespace On Sun, 22 Apr 2007 23:17:45 +0200, The Boss wrote (in article <462bd0f8$0$327$e4fe514c (AT) news (DOT)... Ronald Rood	04-22-2007 11:02 PM Ronald Rood	2	53
Re: Coding Question about user-defined types as parameters On Sun, 22 Apr 2007 00:46:39 GMT, "Dereck L. Dietz" <dietzdl (AT) ameritech (DOT) net> wrote: At least it works when defined in a package spec and... hpuxrac	04-22-2007 10:21 AM sybrandb@hccnet.nl	5	36
conditional In-List I am trying to do a 'conditional In-List'. Here is what I mean. -- BigDataTable create table bdt ( "C1" VARCHAR2(2 BYTE) not null, "C2" VARCHAR2(2... Oxnard	04-21-2007 05:19 PM Maxim Demenko	4	47
using DBMS_METADATA.GET_DDL with table name containing a single quote Hi, I have a table named "Hi$Schema's" in my schema 'myschema'. However, if I try the following sql statement, I get a failure message. SELECT... yaru22	04-21-2007 04:11 PM DA Morgan	3	46
sql_trace hi friend i have 1 query that is using sql_trace=true or alter session set sql_trace=true you can find out the query execution performance but in... manesachin97@gmail.com	04-21-2007 03:53 PM DA Morgan	1	40
Redundant Interconnects on 10g RAC Hi All, I've been setting up a simple 2 node RAC on sun hardware using Solaris 9 and CRS, using 2 interfaces on each node as interconnects. Each... Matt	04-21-2007 03:36 PM DA Morgan	4	32
multiple performance Hello! Theoretical question. For example 1) 10 sessions, each in its own thread, each connected to the same database and executes 10 updates on... Alexander Smirnov	04-21-2007 03:20 PM DA Morgan	5	40
How to send a page from OEM 10gR2? I am new to OEM 10gR2. I have experience with OEM 9i. I have configured OEM 10gR2 to send me an email in the event of problems, but I have not found... bfogarty@gaports.com	04-21-2007 03:11 PM DA Morgan	1	44
How can I download a trial version of Oracle timesten 7.01? I failed to download from the Oracle corp. site. The download link shows that it is 70M zip file. But I could just download a 40K destroyed file. Is... SaintRenault@gmail.com	04-21-2007 03:09 PM DA Morgan	1	48
Exception raised in a loop Hi , Is it possible to raised a exception inside a loop in oracle 9i?? PROCEDURE somprocedure (resultado OUT generic_cursor) IS tmp ... valigula	04-21-2007 03:06 PM DA Morgan	4	44
%CPU column in autotrace - 10gR2 Hi all, Can anyone shed some light about the %CPU column in the output of an autotrace? For one of my application queries, I tuned it by adding a... tony sheng	04-21-2007 02:48 PM DA Morgan	1	44
Accessing Windows based file from Oracle 10G on UNIX Hi.. I'm trying to access a set of files located at the windows folder (c:\temp) by using the UTL_FILE function. The database is located on the UNIX... dubeyvim@gmail.com	04-21-2007 02:33 PM sybrandb@hccnet.nl	5	42
Lots of Oracle10g Audit Log Files, Created every one or two second(s) ( 1 2 ) This is Oracle10g RAC, and there are lots of audit log files created by default under $ORACLE_HOME/rdbms/audit folder, they got created every one or... haiwu.us@gmail.com	04-21-2007 08:33 AM hpuxrac	15	65
tkprof - disk reads greater than query+current Hi, Oracle10g 10.1.0.3 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ----------... wagen123@yahoo.com	04-21-2007 12:59 AM Jonathan Lewis	4	37
ORACLE Spatial Developer Opening We are looking for a Software Engineer for a 6 month contract in Jacksonville, FL. Oracle PL/SQL developer with Oracle Spatial development and... garyz	04-20-2007 10:36 PM garyz	0	35
recover database until cancel Recover standby database until cancel using backup controlfile This question may not be related to standby database per se, but recover database... dbaplusplus@hotmail.com	04-20-2007 09:57 PM K Gopalakrishnan	2	38
How to obtain tablespace creation scripts? Hi, How can I generate tablespace creation scripts provided I've admin access to that DB. Regards, Anand anandmohans@gmail.com	04-20-2007 07:03 PM hpuxrac	3	32
OT - Looking for Oracle DBA slot - Dallas Fort Worth TX Orasaurus (15 years) available at end of April for contract/perm Oracle DBA slot. 10 G R2 and down to V 7. Contact writer at johan.muller (AT) gmail... johan.muller@gmail.com	04-20-2007 02:34 PM fitzjarrell@cox.net	2	37
10G EM DB Console session long ops (progress bar) In the client version of OEM there was a progress bar that was displayed while selecting a session and monitoring activity of SQL Statements. Does... rajesh_choprauk@yahoo.co.uk	04-20-2007 05:22 AM rajesh_choprauk@yahoo.co.uk	2	37
Same query, different results Hi, take these two PL/SQL snippets: declare pznr_tnsw VARCHAR2(200); pdoknr VARCHAR2(200) := 'D1.4655-00-00-00.00-00'; begin SELECT... Thorsten Jens	04-20-2007 12:41 AM Thorsten Jens	4	42
Materialized Views - need metadata Hi, all. Running 10gR2 on Windows as a replication source, and 9.2.0.6 on AIX as the replication target. I need to find some information in my db... BD	04-19-2007 10:22 PM Mladen Gogala	2	39
Installing 32-bit and 64-bit oracle client on windows 2003 Server ( 1 2 ) Hi, I am wondering if we could install 32-bit client of 10g release2 and 64-bit client of the same (allowing delphi 32-bit apps and some... deepak.kollipara@gmail.com	04-19-2007 06:36 PM deepak.kollipara@gmail.com	11	69
Media Management Library for Veritas Hi, Im new to oracle technology. Im using oracle 10g R2 database. I need to use Veritas Tape for oracle Backup. When i do the Backup Settings, there... calms	04-19-2007 04:06 PM BH	1	274
MAXQUERYLEN clarification I am trying to understand MAXQUERYLEN. If anyone could help I would appreciate it. This is what I know: MAXQUERYLEN - The length of a query is... David.E.M....@gmail.com	04-19-2007 04:03 PM David.E.M....@gmail.com	2	41
ref cursor capacity Is it a max capacity per a Ref Cursor? . I only manage to load 180.080 rows ...into it ... Thanks in advance .. valigula	04-19-2007 02:11 PM Mladen Gogala	2	38
hierarchical query with START WITH + hierarchical subquery Hello I try to run a hierachical query A on a Oracle 9i server. The start with clause is a hierarchical subquery B. If I run the subquery... Jürg Schaufelberger	04-19-2007 09:46 AM Mark D Powell	1	36
how to read a file from ASM using BFILENAME and DBMS_LOB.FILEOPEN? Hi, I need your help concerning the following issue. I have generated a dump file using datapump into an ASM diskgroup. Now I want to read... alek	04-19-2007 06:15 AM alek	2	47
sqlplus loop Good day, on a openSUSE 10.2, kernel 2.6.18.2-34-default #1 SMP, and Oracle Release 10.2.0.1.0, after successful installation and creation of a... Wolf Grossi	04-19-2007 04:41 AM Wolf Grossi	1	41
OID: forgot orcladmin password I wish to restore an old OID test system but I forgot the orcladmin password. I tried to google for that but I was able to find only this... yossarian	04-19-2007 03:11 AM yossarian	4	51
archiving stopped, but lsof shows an old file handle Anyway to make oracle release it? Was trying to expand a file system online. Can't umount with file handles open SQL> alter system archive log... NetComrade	04-18-2007 11:24 PM NetComrade	0	47
demo sql using oracle express. Where can I get old sql statements for old schemas. Express only has hr. Looking for old stuff to use when requested by... user	04-18-2007 08:56 PM user	0	47
Firefox is not supported for opening service requests in Metalink? You know, opening a service request is something that I'd rather avoid doing if possible. So someone in Oracle decides to make it pretty and put a... bdbafh	04-18-2007 07:08 PM Tony_Miller	3	35
Basic query tracing and profiling question... ( 1 2 ) I really have absolutely no idea what I'm doing in Oracle beyond logging in with the administrative tools. A full-bore Oracle DBA is on the way, but... Brian K	04-18-2007 06:20 PM joel garry	17	61
Migrate postgres DB to oracle I need some help to migrate a postgres 7.4 DB to a oracle DB. Where can I found tools, SW or some kind of script to help me with this? Thanks, Bruno bcochofel	04-18-2007 05:13 PM bcochofel	6	41
index CLUSTERING_FACTOR can be reduce is there any way to reduce CLUSTERING_FACTOR of any index. peter	04-18-2007 02:24 PM Mladen Gogala	2	35
pl/sql PROBLEM WITH VARIABLES IN EXECUTE IMMEDIATE Hi, I have got litte problem with pl/sql and function:execute immediate . Example, it is a script: my variable:='2007-01-07'; <----- my... mlachajczyk@gmail.com	04-18-2007 11:16 AM gazzag	2	33
determine when password will expire Hi, Oracle10g R2 RHEL 4.2 I set the PASSWORD_LIFE_TIME value by modifying the profile. Is there a way to determine when a password will expire by... wagen123@yahoo.com	04-18-2007 09:06 AM Brian Peasland	3	36
10g have group by bug? hi everyone: I met a strange thing when i do a group by summarize. The base table have nearly 4 million records. When I do group by without add... Havel Zhang	04-18-2007 01:29 AM Havel Zhang	3	42
how to get free discussion on my website ? If you have some questions to ask ,you may go to somewhere as Yahoo for a answer.Yes,maybe you can ask and can get someone's answer ,but you can't... apple@toqm.com	04-17-2007 09:12 PM apple@toqm.com	0	54
buckat in oracle I know it is stupid question for some of you. But I still ask so that it will clear to me. I am very confuse about buckat in oracle. What is this... Steve Robin	04-17-2007 08:15 PM Mladen Gogala	7	43
racgimon.exe CPU usage question Hi, We have 2-node oracle rac db on window platform. Oracle Clusterware was upgraded to 10.2.0.3 with "10g Release 2 (10.2.0.3) Patch Set 2 for... GuangMei	04-17-2007 07:11 PM hpuxrac	1	77
Website about the PeopleSoft-Oracle acquisition and ERP in general Hey guys, I just went to www.peoplesoft-planet.com. It's an interesting website about the PeopleSoft-Oracle acquisition and ERP in general. I thought... mike	04-17-2007 06:27 PM mike	0	43
query plan, outln, statistics, off topic Hi, 1) For plan stability : Meaning I do not want too many surprises with query plan explain plan : for that one solution is use outline. However I... renu_p_r@yahoo.com	04-17-2007 02:31 PM renu_p_r@yahoo.com	3	37
Export Type Long Hello, since I can export to text a field type long? JuanMa	04-17-2007 01:20 PM sybrandb@hccnet.nl	2	48
perl script for extracting csv files on the fly This may be of some use; I use it all the time (RH E 4; Oracle 10.2.0.1). Save the perl code below and make sure you can execute it. Change the host,... johan.muller@gmail.com	04-17-2007 12:58 PM johan.muller@gmail.com	0	39
Before Insert Trigger - Capture In Value to Compare to Value in Existing Table Before inserting a row in a table I would like to check the value of a particular field in the new candidate row against the existence of the value... rm	04-17-2007 11:28 AM Valentin Minzatu	3	47
Help with my sql load performance Dear group, I am trying to increase my SQL Loader's performace. My table has a lot of columns, 200 columns, but most of them are null. The... emdproduction@hotmail.com	04-17-2007 10:13 AM DA Morgan	7	41

Page 109 of 411

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