I am here in the middle of the warehouse to extract data, kettle suggest there is insufficient space on the table, looked at the found that the size of more than 20 g,
Try to use additional data file way of expanding the table space

The ALTER in TABLESPACE NALI ADD DATAFILE
'D: \ APP \ ADMINISTRATOR \ PRODUCT \ 11.2.0 \ DBHOME_1 \ DATABASE \ NALI2 DBF' SIZE
10240 mAUTOEXTEND ON NEXT 1024 m

In navicat carried out this sentence, because time is too long other queries to break even,
Thought that this was broken so stopped the query, but the file already in the database table space,
In order to prevent an accident online search under the
Using the alter database datafile 'D: \ APP \ ADMINISTRATOR \ PRODUCT \ 11.2.0 \ DBHOME_1 \ database \ NALI2 DBF' offline drop,
And removed manually NALI2. DBF file, again with the above statement attached a NALI3. DBF,
But the use of the select the name from v $datafile; See NALI2. DBF remains
And
After extracting still prompt NALI. DBF table space is not enough, how to completely delete a data file, please NALI2. DBF,
And increasing the tablespace size...

CodePudding user response:

1, create a new table space, the name is NALI_BAK
2, put the table in table space NALI all move to NALI_BAK
3, delete NALI
4, rename NALI_BAK NALI