Re: Can't export!

swong_at_ED.RAY.COM wrote:
>To all Oracle gurus,
>
>We just installed Oracle7 7.1.3 on a Dec Vax. I tried to export a table and
>the entire database and I get the same error messages.
>
>EXP-00008: ORACLE error 900 encountered
>ORA-00900: invalid SQL statement
>EXP-00000: Export terminated unsuccessfully
>
>I was doing the export interactively (the exp had prompts).
>Any help would be appreciated. Thanks.
>
>Stephen W.
>------------------------
>All opinions are my own, not my employer
>

Stephen,

The first question I have for you is: are the export views installed in the data dictionary correctly. You can check this by connecting as SYS and search for any views beginning with 'exp7'. This views are queried by export. Most likely you would of course receive a ORA-904 error (table or view does not exist). You may try to solve it by running the script catexp.sql in the ORA_RDBMS\admin directory connected as SYS. This will recreate the export views. As far as I know they're not created automatically anymore as in previous releases. Also (although this will probably not apply to your situation) when you want to make a V6 export (by running the V6 exp executable of course) be sure the V6 export views are created by running catexp6.sql in the same directory. Omitting this will cause the same type of error (which was how I originally discovered it)

Hope this helps

Sybrand Bakker
Senior IS Analyst

The same standard disclaimer applies. Received on Wed Aug 02 1995 - 00:00:00 CEST