为什么有很多表ORACLE默认12c？ [英] Why many tables ORACLE default 12c?

问题描述

创建一个新的数据库（基本和高级），这是我第一次处理Oracle，其中我不知道为什么这么多的表，触发器，视图和其他对象只想创建一个关系数据库为空。 / p>

有没有其他方法可以做到这一点，还是有一些我错过的理解？

谢谢。 >

捕获：

解决方案

这些对象由 SYS 用户拥有。您可以使用以下查询进行验证：

  SELECT * FROM DBA_OBJECTS WHERE OWNER ='SYS'; 
  

要查看其他用户拥有的对象，请参阅：

  SELECT * FROM DBA_OBJECTS WHERE OWNER<> 'SYS'; 
  

您必须以 SYS AS SYSDBA 登录， SYS用户拥有的对象。

请记住，

• SYS / SYSDBA是特殊的


• SYS / SYSDBA是Oracle专有的，因此不需要将SYS（或SYSDBA）用于一般数据库用途，而是用于管理/维护目的（启动，关闭，备份，恢复） （尝试以我用SYS / SYSDBA开头开头一个SR / TAR，您会看到立即回答）


• SYS / SYSDBA不像任何其他用户


• 使用SYS / SYSDBA时，Oracle会停用某些代码路径并激活其他代码路径。


• 无论使用SYS / SYSDBA做什么，




永远不会使用SYS / SYSDBA来处理任何其他用户可以执行的操作。
仅对于其他人无法执行的操作使用SYS / SYSDBA。





请参阅 this p>


Creating a new database (basic and advanced), It's my first time dealing with Oracle, in which I do not know why so many tables, triggers, views and other objects when only wanted to create a relational data base empty.

Is there another way to do this or is there something I missed understand?

Thank you.

Capture:

解决方案

Those objects are owned by SYS user. You could verify it using following query:

SELECT * FROM DBA_OBJECTS WHERE OWNER = 'SYS';

To see the objects owned by other users, see:

SELECT * FROM DBA_OBJECTS WHERE OWNER <> 'SYS';

You must have logged in as SYS AS SYSDBA, therefore able to view the objects owned by SYS user.

Remember,

• SYS/SYSDBA is special
• Never ever use SYS (or SYSDBA) for general database purpose, but for administration/maintenance purpose (startup, shutdown, backup, recover)
• SYS/SYSDBA is Oracle proprietary (try to open a SR/TAR starting with "i did that with SYS/SYSDBA" and you'll see the immediate answer)
• SYS/SYSDBA does not act like any other user
• When you use SYS/SYSDBA Oracle deactivates some code path and activates others
• Whatever you do with SYS/SYSDBA will neither validate nor invalidate the same thing with any other user.

NEVER EVER use SYS/SYSDBA for anything that can be done by another user. Use SYS/SYSDBA ONLY for something that can't be done by someone else.

See this answer on AskTom by Tom Kyte.

这篇关于为什么有很多表ORACLE默认12c？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！