
7 Dec
2005
7 Dec
'05
2:04 p.m.
Hi Florent, Florent Guiliani schrieb:
current_timestamp doesn't exist, Oracle use instead sysdate.
after replaced all current_timestamp with sysdate, others statments are invalids because some right-quote are missing. Here is the patch in attachment.
No. It works fine for me. Just use it like: shell> cat scripts/database/otrs-schema.oracle.sql | sqlplus "user/pw" shell> cat cripts/database/initial_insert.sql | sqlplus "user/pw"
Florent,
-Martin