Oracle dba_data_files 表不存在
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1423170/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle dba_data_files table doesn't exist
提问by Eli Courtwright
I've been trying to access the dba_data_files tableto see whether the autoextendis turned on for my data files. However, even though I'm using Oracle 10g, this table seems to not exist:
我一直在尝试访问dba_data_files 表以查看是否autoextend为我的数据文件打开了该表。但是，即使我使用的是 Oracle 10g，这张表似乎也不存在：
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select * from dba_data_files;
select * from dba_data_files
*
ERROR at line 1:
ORA-00942: table or view does not exist
Is there some other way to check and even change whether a data file for a particular tablespace has the autoextend option turned on?
是否有其他方法可以检查甚至更改特定表空间的数据文件是否打开了自动扩展选项？
回答by dpbradley
You should make sure you're connecting with an account that has privileges to see this view - try the SYSTEM account if you have that password, otherwise have your DBA grant the SELECT_CATALOG_ROLE to the account you are using.
您应该确保您正在连接一个有权查看此视图的帐户 - 如果您有该密码，请尝试使用 SYSTEM 帐户，否则让您的 DBA 将 SELECT_CATALOG_ROLE 授予您正在使用的帐户。
回答by moleboy
You should be able to do this through the oracle enterprise manager under Administration
您应该能够通过管理下的 oracle 企业管理器执行此操作
