如下语句: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.
ORACLE的列名、表名、标识符不能超过30个字符的限制!!
但是我执行select * from ASPNET_MEMBERSHIP 就可以,这个怎么办?我总不能把列名改了吧?