Home » RDBMS Server » Server Utilities » exp failure due to invalid view-
exp failure due to invalid view- [message #253956] Wed, 25 July 2007 06:36 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
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 Go to previous message
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
Previous Topic: While Export one of our DB I've got the error
Next Topic: SQL*Loader-704
Goto Forum:
  


Current Time: Fri Dec 09 07:50:10 CST 2016

Total time taken to generate the page: 0.09252 seconds