Hi,

I loaded data into a table referenced by other table(Pk, Fk Relation and No cascade delete) via sql loader. the data loaded successfully after using "replace into table" statement, before i tried truncate,append,insert statements but data not loaded,thrown error about violation of referential integrity. then i read Oracle Docs about insert,append,Truncate and Replace,every statement has its own functionality. but in that they explained about truncate and replace, as truncate truncate the table and loads data but replace delete the table and loads the data. but with delete statement also we can not delete the data having Child records, so my question is
How is this possible with replace,why with not others like Truncate,Insert?

I hope i provided sufficient information.

Thank you in advance

SQL> create table t1 ( x int primary key );

Table created.

SQL> create table t2 ( y int, x int references t1(x));

Table created.

SQL>
SQL> insert into t1 values (1);

1 row created.

SQL> delete from t1;

1 row deleted.

SQL>
SQL> insert into t1 values (1);

1 row created.

SQL> truncate table t1;
truncate table t1
               *
ERROR at line 1:
ORA-02266: unique/primary keys in table referenced by enabled foreign keys