RE: Info on VLDB/DW

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 28 Sep 2004 09:17:15 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A2133DF0C@usahm018.exmi01.exch.eds.com>

I believe the "into emp" on line 10 is the problem. Like on line 7 where you just type update without the table name I think the insert is the same. The merge into provides the target.

HTH -- Mark D Powell --

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Katz.C_at_forces.gc.ca Sent: Monday, September 27, 2004 4:44 PM To: bobmetelsky_at_comcast.net; oracle-l_at_freelists.org Subject: RE: Info on VLDB/DW

Bob,
I can't answer your questions directly, but I think, Tim Gorman's book - Essential Oracle8i Data Warehousing can.

Re your signature:
I just struggled today with an error message, It took me quite a while to realize why Oracle was telling me that the values keyword was missing. (An over-simplified version of the statement follows) Are Oracle error messages not keeping up with the code?

SQL> Begin
  2 Merge into emp e
  3 Using (select *
  4 from emp_temp) t
  5 on (e.empno = t.empno)
  6 when matched then

  7      Update  set
  8          e.hiredate = t.hiredate
  9    when not matched then
 10        Insert into emp  (empno, hiredate)
 11        values  (t.empno, t.hiredate);

12 End;
13 /

      values  (t.empno, t.hiredate);
     *

ERROR at line 11:
ORA-06550: line 10, column 14:
PL/SQL: ORA-00926: missing VALUES keyword

chaim
http://www.learntorah.net

-----Original Message-----

From: Bob Metelsky [mailto:bobmetelsky_at_comcast.net] Sent: Monday, September 27, 2004 10:18 AM To: oracle-l_at_freelists.org
Subject: Info on VLDB/DW

Good Morning All, I was hoping someone here can point me to pertinent documents which address (DW). I know there are tons of online docs via google or metalink but was wondering if people her had their own favorites. Im particullary interested in nutshell concepts of:

1 reasonable maximum datafile sizes & physical disk striping 2 getting data from prod to dw
3 various partitioning
4 stratigies for backup + recovery

Thanks
Bob

--

"Oracle error messages being what they are, do not highlight the correct cause of fault, but will identify some other error located close to where the real fault lies."

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 28 2004 - 08:13:34 CDT