Oracle learns six Delete table spaces, statements for data files, and methods for importing and exporting DMP files (ongoing updates)

To delete a tablespace, delete the data file first

For example, this example

CREATEtablespace sthsgimgdb_space11 datafile'D:\ORACLEDATABASE\JinHuaDataBase\STHSGIMGDB_SPACE11_01'SIZE 1M Autoextend on NEXT50M MAXSIZE UNLIMITED,'D:\ORACLEDATABASE\JinHuaDataBase\STHSGIMGDB_SPACE11_02'SIZE 1M Autoextend on NEXT50M MAXSIZE UNLIMITED,'D:\ORACLEDATABASE\JinHuaDataBase\STHSGIMGDB_SPACE11_03'SIZE 1M Autoextend on NEXT50M MAXSIZE UNLIMITED,'D:\ORACLEDATABASE\JinHuaDataBase\STHSGIMGDB_SPACE11_04'SIZE 1M Autoextend on NEXT50M MAXSIZE UNLIMITED,'D:\ORACLEDATABASE\JinHuaDataBase\STHSGIMGDB_SPACE11_05'SIZE 1M Autoextend on NEXT50M MAXSIZE unlimitedloggingonlinePERMANENTEXTENT MANAGEMENT LOCAL autoallocateblocksize 8KSEGMENTSPACEMANAGEMENT MANUAL;

You can delete this

Alter Database ' Where dbf files are located ' drop;

Delete all the data files in this tablespace and then delete them

DROP Tablespace STHSGIMGDB_SPACE11

Of course, there's this way.

DROP  and datafiles;

Brutally deleting everything inside the table space.

Then introduce the import and export, the main or use DOS to operate, note, do not use DOS into the sqlpuls, directly in the DOS interface input

IMP username  / password @ database name  touser= which user name to import  fromuser= from which user name to import the past    file= where the files are located

The exported method is similar to this, but IMP is replaced with exp, and using DOS is less time consuming than using Oracle's tools, and soon

Oracle learns six Delete table spaces, statements for data files, and methods for importing and exporting DMP files (ongoing updates)