OraFAQ Forum: Server Utilities » exp failure due to invalid view-

Home » RDBMS Server » Server Utilities » exp failure due to invalid view-

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

exp failure due to invalid view- [message #253956]

Wed, 25 July 2007 06:36

rrajesh_jain
Messages: 13
Registered: May 2007

Junior Member

hi friends

during export i face a problem regarding view and that is
_all_repcolumn owner name is sys and its a invalid view i compile the view and it show view compile with error ora-00911 invalid character now suggest me how to validate this view
plz help

regards
rajesh

[Updated on: Wed, 25 July 2007 06:40]

Report message to a moderator

Re: exp failure due to invalid view- urgent [message #253959 is a reply to message #253956]

Wed, 25 July 2007 06:38

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I suggest you to avoid "urgent" as nothing is urgent in forum and this prevent some from answering you.

Regards
Michel

[Updated on: Wed, 25 July 2007 06:38]

Report message to a moderator

Re: exp failure due to invalid view- urgent [message #254037 is a reply to message #253959]

Wed, 25 July 2007 10:33

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

ORA-00911: invalid character
Cause: identifiers may not start with any ASCII character other than letters and numbers. $#_ are also allowed after
the first character. Identifiers enclosed by doublequotes may contain any character other than a doublequote.
Alternative quotes (q'#...#') cannot use spaces, tabs,
or carriage returns as delimiters. For all other contexts,
consult the SQL Language Reference Manual.
Action: none

Report message to a moderator

Previous Topic:	While Export one of our DB I've got the error
Next Topic:	SQL*Loader-704

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 22 22:16:21 CDT 2024