Martin Edenhofer a écrit :
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"
I'm using Oracle 8.1.7.4 and current_timestamp or initial_insert.sql are not working :( Another defect in otrs-schema-post.oracle.sql: ALTER TABLE valid ADD CONSTRAINT fk_valid_create_by_id FOREIGN KEY (create_by) REFERENCES system_user(id); This statments failed because after initial_insert.sql, the table system_user contains the Admin user and his ID is 3 not 1. Florent,