disable table locks to prevent insert append

View All Public Scripts Login to Run Script

Statement 1
```
create table DEMO (n number)
```
ORA-00955: name is already used by an existing object

Statement 2

insert /*+ append */ into DEMO select rownum from xmltable('1 to 1000')

1000 row(s) inserted.

Statement 3
```
select count(*) from DEMO
```
COUNT(*)
3000
Statement 4
```
commit
```
Statement processed.
Statement 5
```
alter table DEMO disable table lock
```
ORA-00069: cannot acquire lock -- table locks disabled for DEMO

COUNT(*)
3000

Statement 6

insert /*+ append */ into DEMO select rownum from xmltable('1 to 1000')

1000 row(s) inserted.

COUNT(*)
4000

Additional Information