Oracle 9i Import Error

[tgopalakrishnan12]

When we import the Schema through .SQL files, we are getting the below given error messages on Oracle 9i. The same does not happen with Oracle 8i. This is becasue Oracle9i is not recognising "..." and "new line" character.

Eg: insert into system_constraintmetadata (constraint_type, appconstraint_type, active_chg_affects_open_sched, hidden, singleton, display_name, custom, descr, system_generated, java_class, default_enforce_order, semi_custom, taskgrouptype, penaltytype, violation_msg_infeasible, notes ) values ('TEMPORAL_MIN_MAX', 'Timepoint Relationship -- min/max', 'Y', 'N', 'N', 'Timepoint Relationship -- min/max', 'N', 'Use this constraint to define a task''s timepoint value relative to the earliest or latest scheduled time from a set of timepoint values.

Task1.time[timepointA] RELATION MIN(Task2.time[timepointB, Task3.time[timepointB],..., TaskN.time[timepointB])

or Task1.time[timepointA] RELATION MAX(Task2.time[timepointB, Task3.time[timepointB],..., TaskN.time[timepointB])


Error Message
==============
SP2-0734: unknown command beginning "If Y, P1 a..." - rest of line ignored.
SP2-0734: unknown command beginning "If N, RPS ..." - rest of line ignored.
ERROR:ORA-01756: quoted string not properly terminated
SP2-0734: unknown command beginning "1.Skip ''A..." - rest of line ignored.
SP2-0734: unknown command beginning "2.In order..." - rest of line ignored.
SP2-0734: unknown command beginning "This flag ..." - rest of line ignored.
ERROR:ORA-01756: quoted string not properly terminated
SP2-0734: unknown command beginning "WO_PLANNED..." - rest of line ignored.
SP2-0734: unknown command beginning "For schedu..." - rest of line ignored.
ERROR:ORA-01756: quoted string not properly terminated
SP2-0042: unknown command "WO_EPST}" - rest of line ignored.
SP2-0734: unknown command beginning "For unsche..." - rest of line ignored.
ERROR:ORA-01756: quoted string not properly terminated
1 row created.
1 row created.
SP2-0734: unknown command beginning "If N, acti..." - rest of line ignored.
ERROR:ORA-01756: quoted string not properly terminated

 

[alexhu]

I would like to help, but don't understand what you are doing

What does 'When we import the Schema through .SQL files' mean ?

Alex

 

[tgopalakrishnan12]

I am importing the Schema and data through 4 .SQL files.

 

[sem]

I suppose that "If Y, P1 a" is part of the code contained in your sql file, thus the error was not produced by insert statement itself. If you use some pl*sql procedure (a set of CONDITIONAL statements), it should be enclosed into begin/end. Regards, Dima