Info on VLDB/DW 2004-09-28 - By Powell, Mark D
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@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of Katz.C@(protected)
Sent: Monday, September 27, 2004 4:44 PM
To: bobmetelsky@(protected); oracle-l@(protected)
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 (See ORA-06550.ora-code.com): line 10, column 14:
PL/SQL: ORA-00926 (See ORA-00926.ora-code.com): missing VALUES keyword
chaim
http://www.learntorah.net
-- --Original Message-- --
From: Bob Metelsky [mailto:bobmetelsky@(protected)]
Sent: Monday, September 27, 2004 10:18 AM
To: oracle-l@(protected)
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
|
|
