如下语句:CREATE OR REPLACE VIEW "VW_ASPNET_MEMBERSHIPUSERS"("USERID", "PASSWORDFORMAT", "MOBILEPIN", "EMAIL", "LOWEREDEMAIL", "PASSWORDQUESTION", "PASSWORDANSWER", "ISAPPROVED", "ISLOCKEDOUT", "CREATEDATE", "LASTLOGINDATE", "LASTPASSWORDCHANGEDDATE", "LASTLOCKOUTDATE", "FAILEDPASSWORDATTEMPTCOUNT", "FAILEDPASSWORDATTEMPTWINDOWSTA", "FAILEDPASSWORDANSWERATTEMPTCOU", "FAILEDPASSWORDANSWERATTEMPTWIN", "COMMENT", "APPLICATIONID", "USERNAME", "MOBILEALIAS", "ISANONYMOUS", "LASTACTIVITYDATE") AS
SELECT ASPNET_MEMBERSHIP.USERID ,
ASPNET_MEMBERSHIP.PASSWORDFORMAT ,
ASPNET_MEMBERSHIP.MOBILEPIN ,
ASPNET_MEMBERSHIP.EMAIL ,
ASPNET_MEMBERSHIP.LOWEREDEMAIL ,
ASPNET_MEMBERSHIP.PASSWORDQUESTION ,
ASPNET_MEMBERSHIP.PASSWORDANSWER ,
ASPNET_MEMBERSHIP.ISAPPROVED ,
ASPNET_MEMBERSHIP.ISLOCKEDOUT ,
ASPNET_MEMBERSHIP.CREATEDATE ,
ASPNET_MEMBERSHIP.LASTLOGINDATE ,
ASPNET_MEMBERSHIP.LASTPASSWORDCHANGEDDATE ,
ASPNET_MEMBERSHIP.LASTLOCKOUTDATE ,
ASPNET_MEMBERSHIP.FAILEDPASSWORDATTEMPTCOUNT ,
ASPNET_MEMBERSHIP.FAILEDPASSWORDATTEMPTWINDOWSTART ,
ASPNET_MEMBERSHIP.FAILEDPASSWORDANSWERATTEMPTCOUNT ,
ASPNET_MEMBERSHIP.FAILEDPASSWORDANSWERATTEMPTWINDOWSTART ,
ASPNET_MEMBERSHIP.COMMENT ,
ASPNET_USERS.APPLICATIONID ,
ASPNET_USERS.USERNAME ,
ASPNET_USERS.MOBILEALIAS ,
ASPNET_USERS.ISANONYMOUS ,
ASPNET_USERS.LASTACTIVITYDATE
FROM ASPNET_MEMBERSHIP INNER JOIN ASPNET_USERS
ON ASPNET_MEMBERSHIP.USERID = ASPNET_USERS.USERID ;
报错如下
错误报告:
SQL 错误: ORA-00972: identifier is too long
00972. 00000 - "identifier is too long"
*Cause: An identifier with more than 30 characters was specified.
*Action: Specify at most 30 characters.
SELECT ASPNET_MEMBERSHIP.USERID ,
ASPNET_MEMBERSHIP.PASSWORDFORMAT ,
ASPNET_MEMBERSHIP.MOBILEPIN ,
ASPNET_MEMBERSHIP.EMAIL ,
ASPNET_MEMBERSHIP.LOWEREDEMAIL ,
ASPNET_MEMBERSHIP.PASSWORDQUESTION ,
ASPNET_MEMBERSHIP.PASSWORDANSWER ,
ASPNET_MEMBERSHIP.ISAPPROVED ,
ASPNET_MEMBERSHIP.ISLOCKEDOUT ,
ASPNET_MEMBERSHIP.CREATEDATE ,
ASPNET_MEMBERSHIP.LASTLOGINDATE ,
ASPNET_MEMBERSHIP.LASTPASSWORDCHANGEDDATE ,
ASPNET_MEMBERSHIP.LASTLOCKOUTDATE ,
ASPNET_MEMBERSHIP.FAILEDPASSWORDATTEMPTCOUNT ,
ASPNET_MEMBERSHIP.FAILEDPASSWORDATTEMPTWINDOWSTART ,
ASPNET_MEMBERSHIP.FAILEDPASSWORDANSWERATTEMPTCOUNT ,
ASPNET_MEMBERSHIP.FAILEDPASSWORDANSWERATTEMPTWINDOWSTART ,
ASPNET_MEMBERSHIP.COMMENT ,
ASPNET_USERS.APPLICATIONID ,
ASPNET_USERS.USERNAME ,
ASPNET_USERS.MOBILEALIAS ,
ASPNET_USERS.ISANONYMOUS ,
ASPNET_USERS.LASTACTIVITYDATE
FROM ASPNET_MEMBERSHIP INNER JOIN ASPNET_USERS
ON ASPNET_MEMBERSHIP.USERID = ASPNET_USERS.USERID ;
报错如下
错误报告:
SQL 错误: ORA-00972: identifier is too long
00972. 00000 - "identifier is too long"
*Cause: An identifier with more than 30 characters was specified.
*Action: Specify at most 30 characters.
解决方案 »
- sqlloader如何同时导入多个数据文件
- 函数问题,急!!!!在线等
- like通配符语句使用and检索不出来数据,为什么呢?
- 请教高手,aix服务器Oracle9i 升级补丁 92080 的安装步骤
- Oracle查询的效率问题
- 备份oracle9i时出现错误,高手能来看看吗,急!!在线等待!
- 求一oracle更新语句!!!急啊,在线等
- 急,急,急!数据库停电.再进入出现"ora-01033 oracle initialization or shutdown in progress"
- 如何在已有分区之前插入新的分区
- 请教高手:怎样往分区表中追加数据?而数据取之于同一分区表中的另一分区?(急急!在线等待)
- 提示:ORA-12704: 字符集不匹配
- 这个几个列的和的值怎么写,错误在下面
ORACLE的列名、表名、标识符不能超过30个字符的限制!!
但是我执行select * from ASPNET_MEMBERSHIP 就可以,这个怎么办?我总不能把列名改了吧?