CODEWITHSUNDEEP
oracle-databasedatabase-administration
siva krishna
siva krishna

Reputation: 29

ORA-01900: LOGFILE keyword expected when trying to drop tablespace

SQL> alter database drop tablespace XXX including contents and datafiles;
alter database drop tablespace XXX including contents and datafiles
                    *
ERROR at line 1:
ORA-01900: LOGFILE keyword expected

Note : I do not have datafile regarding this tablespace I have deleted it manually.

Please advice me and also if any article regarding backup tablespaces please share

Upvotes: 0

Views: 3145

Answers (1)

Alex Poole
Alex Poole

Reputation: 191275

You seem to be mixing up syntax from different commands. drop tablespace is a standalone statement:

enter image description here

The alter database statement is separate; it has a drop logfile clause, but not drop tablespace. The parser is seeing the drop ... in your statement and is expecting the next word to therefore be logfile - and since it isn't, it generates the error you see.

So you only need to do:

drop tablespace XXX including contents and datafiles;

(assuming you're really sure you do want to get rid of it permenantly, of course!)

Upvotes: 1

Related Questions