Oracle 数据库表空间下降

嗨，团队，

我们已经给了系统，sysaux，undo，temp表空间巨大的大小分配现在操作系统级别的空间问题，所以，我可以删除和重新创建一个表空间在Oracle是oracle表空间它是停机活动？我们该怎么做呢？

注意-
存储在单独表空间中的所有用户数据不在这些系统，sysaux，撤消表空间中。

我可以在没有关闭时间的情况下在生产环境中删除并重新创建临时表空间吗？


谢谢

从文档中:

You cannot drop the SYSTEM tablespace. You can drop the SYSAUX tablespace only if you have the SYSDBA system privilege and you have started the database in UPGRADE mode.

和

You cannot drop an undo tablespace if it is being used by any instance or if it contains any undo data needed to roll back uncommitted transactions.

You cannot drop a tablespace that has been designated as the default tablespace for the database. You must first reassign another tablespace as the default tablespace and then drop the old default tablespace.

You cannot drop a temporary tablespace if it is part of the database default temporary tablespace group. You must first remove the tablespace from the database default temporary tablespace group and then drop it.

You cannot drop a temporary tablespace if it contains segments that are in use by existing sessions. In this case, no error is raised. The database waits until there are no segments in use by existing sessions and then drops the tablespace.

http://docs.oracle.com/database/122/SQLRF/DROP-TABLESPACE.htm#SQLRF01807

您可以使用以下方法更改撤消表空间:

ALTER SYSTEM SET UNDO_TABLESPACE = undotbs_02;
复制

虽然你会得到一个错误，如果以下任何一个是正确的:

The tablespace does not exist

The tablespace is not an undo tablespace

The tablespace is already being used by another instance (in a RAC environment only)

https://docs.oracle.com/cd/B28359_01/server.111/b28310/undo005.htm#ADMIN11477

You can add a new temporary tablespace whenever you want. 和 remove the old one subject to the above restrictions. But be aware that this will ultimately grow again depending on how much temp space your SQL uses.

https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces002.htm#ADMIN11366