Oracle
in [SQL]
|
parallel and append hint in insert statement I have a statement as below: INSERT /*+ APPEND */ INTO emp SELECT /*+ PARALLEL (temp_emp, 4) */ FROM temp_emp As you can see, SELECT is set to perform in 4 processes. Will the insert also be executed by 4 parallel processes without the explicit PARALLEL hint in the insert clause, since the select is done in ... 22 Apr 2005 15:20
Creating PFILE from SPFILE with *. I create my PFILE from my SPFILE using SQL> CREATE PFILE FROM SPFILE It creates a file when I OPEN it is NOT a NORMAL INIT.ORA File... Everyline starts with *. Example: *.aq_tm_processes=1 *.compatible='9.2.0.0.0' When I start my DB with this file... it gives me ERRORS... SQL> startup nomount; ORA-01078: ... 1 Mar 2005 17:34
Clustering Basics with RAC? If I have 2 servers running Win2003 Server Standard Edition, can I cluster them with the aid of RAC? Or do I need to use Win2003 Server Enterprise Edition to cluster? This is all new to me and I'm trying to teach myself!! Any help to get me started or links to useful help sites most appreciated. Nibs ... 25 Feb 2005 21:33
Resolved ORA-27302 error, but how to fix? Hi, I have Oracle 9i running on a Solaris 9 system. Yesterday, when trying to startup one of the database instances using OEM, I was getting an ORA-27302 error (along with some others). There was also an ORA-27301 error among them. I tried to diagnose the problem, checking disk space, etc., but that looked ... 25 Feb 2005 16:51
Roles I have the following scenario that I need guidance on. I have a database user (user1) that I want to export and later import the user into the same schema name. The user1 has had system privileges granted to it by SYS. There are roles created that give access to the objects user1 owns. All users who have a... 24 Feb 2005 10:06
usernames hi how to get usernames from oracle database using shell script (from cmd line) T. ... 24 Feb 2005 10:06
ORA-01044 after migration Oracle-DB 8i to 9i / return large OLE DB RecordSets to VB6 After a migration from Oracle 8i to 9i (Windows) we found that some of our stored procedures that return some thousand records to a VB6 component via OLE DB RecordSet objects fail with ORA-01044 ("Grýýe 6000000 des Puffers fýr Variable ýberschreitet Hýchstwert von 4194304") [german] (english: size string of bu... 24 Feb 2005 10:06
Installing Oracle client over existing database Hi, I have Oracle 9i server installed on a machine. For some reason, the Oracle client has gotten messed up. Can I reinstall the client on the same machine? Will it affect the existing database on that machine? Do i have to select the same oracle home or a new one? Thanks, Kirtan ... 24 Feb 2005 10:06
Questions on PLAN_TABLE Hi, owning up I have been using Oracle for over 3 years as a middleware developer regularly using an Oracle database and I have never really understood the Oracle Plan table. Despite much effort over the past few days, I am still not sure I do and would like to ask the experts in this newsgroup to clear somethi... 24 Feb 2005 10:06
*NEWBIE* Help needed for decoding that ... Could anyone help me understand this : ..........4.,......O........"......(DESCRIPTION=(CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle)))(ADDRESS=(PROTOCOL=tcp)(HOST=ora10g.melca.xaymaca.com)(PORT=1521))).A.......7(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.10)(PORT=3230)) What is the port 3230 need... 24 Feb 2005 10:06 |