oracle ORA-00972 标识符太长：在创建表空间时
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/3382833/
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
ORA-00972 Identifier is too long: while creating tablespace
提问by relyt
This is a practice assignment where I have to create a table space with two datafiles. We have to use the exact naming conventions that are given to us. I believe I have it right, but I get this error: "ORA-00972: identifier is too long". I think I'm getting this because the path and filename are so long. The question is, how do I get around this?
这是一个练习作业，我必须用两个数据文件创建一个表空间。我们必须使用提供给我们的确切命名约定。我相信我是对的，但我收到了这个错误：“ ORA-00972：标识符太长”。我想我得到这个是因为路径和文件名太长了。问题是，我该如何解决这个问题？
Thanks!
谢谢！
CREATE TABLESPACE CTTT444_tbs
DATAFILE "C:\oracle\product.2.0\oradata\cttt444_1.dbf" SIZE 15M,
DATAFILE "C:\oracle\product.2.0\oradata\cttt444_2.dbf" SIZE 15M,
AUTOEXTEND ON
NEXT 5m
MAXSIZE 100m);
回答by Pop
File specificationshould be single quotes. Try:
文件规范应该是单引号。尝试：
CREATE TABLESPACE CTTT444_tbs
DATAFILE 'C:\oracle\product.2.0\oradata\cttt444_1.dbf' SIZE 15M,
DATAFILE 'C:\oracle\product.2.0\oradata\cttt444_2.dbf' SIZE 15M
AUTOEXTEND ON
NEXT 5m
MAXSIZE 100m;
It also looks like you have some syntax errors in the command (such as the right parenthesis).
看起来您在命令中也有一些语法错误（例如右括号）。
回答by relyt
FYI for those with the same issue. This seemed to work for me.
供有同样问题的人参考。这似乎对我有用。
CREATE TABLESPACE CTTT444_tbs
DATAFILE 'C:\oracle\product.2.0\oradata\cttt444_1.dbf' SIZE 15M,
'C:\oracle\product.2.0\oradata\cttt444_2.dbf' SIZE 15M
AUTOEXTEND ON
NEXT 5m
MAXSIZE 100m;
OR
或者
CREATE TABLESPACE CTTT444_tbs
DATAFILE 'C:\oracle\product.2.0\oradata\cttt444.dbf' SIZE 15M
AUTOEXTEND ON
NEXT 5m
MAXSIZE 100m;
ALTER TABLESPACE CMIS420_tbs ADD DATAFILE 'C:\oracle\product.2.0\oradata\cttt444.dbf' SIZE 15M;
