Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

on update cascade

758466Mar 12 2010 — edited Mar 12 2010
help wanted on update cascade. How can i do it in oracle?
SQL> create table t(
2 id number(1),
3 name varchar2(10),
4 constraint i_pk primary key (id)
5 );

Table created.

SQL> create table m (
2 id number(1),
3 class varchar2(4),
4 constraint i_fk foreign key (id)
5 references t (id) on update cascade
6 );
references t (id) on update cascade
*
ERROR at line 5:
ORA-00905: missing keyword

Comments

Mahir M. Quluzade

You must check control files, is correct place or not,

show parameter control_files

after mount, you  can check data file, redo log , temp files directories.

they must be in correct directory

Mahir

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 9 2010
Added on Mar 12 2010
2 comments
4,488 views