Truncate tables with Cache

Question

I have a hotel table and reserve table.

In the reserve table I have the primary key of the hotel table as foreign key.

I can’t truncate because there are relationships between keys. How can I?

I’ve already done:

truncate table hospede on delete cascade;

But I can’t.

Just remembering that the fk are with on delete cascade. And that use version 11g express Edition.

Answer 1

The on delete cascade should only be used in some instructions DDL (data Definition language), and not in instructions DML (data Manipulation language). That is, it is to use only where there is change in the structure of the tables, and not in the data. But in your case, you just want to erase the data without changing the structure of the tables.

So here’s what I’d do:

TRUNCATE TABLE hospede;
TRUNCATE TABLE reserva;
TRUNCATE TABLE hotel;

The order of the instructions is important.