ORA-00972标识符太长:创建表空间时 [英] ORA-00972 Identifier is too long: while creating tablespace

问题描述

这是一个练习作业，其中我必须创建带有两个数据文件的表空间.我们必须使用提供给我们的确切命名约定.我相信我没错，但是出现了以下错误:" ORA-00972:标识符太长".我想得到这个是因为路径和文件名太长了.问题是，我该如何解决?

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?

谢谢！

CREATE TABLESPACE CTTT444_tbs
DATAFILE "C:\oracle\product\10.2.0\oradata\cttt444_1.dbf" SIZE 15M,
DATAFILE "C:\oracle\product\10.2.0\oradata\cttt444_2.dbf" SIZE 15M,
AUTOEXTEND ON
NEXT 5m
MAXSIZE 100m);

推荐答案

文件规范应为单引号.试试:

CREATE TABLESPACE CTTT444_tbs
DATAFILE 'C:\oracle\product\10.2.0\oradata\cttt444_1.dbf' SIZE 15M,
DATAFILE 'C:\oracle\product\10.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).

这篇关于ORA-00972标识符太长:创建表空间时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！