- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- oracle error 904 while attempting to do full db ex...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-17-2002 06:16 PM
тАО11-17-2002 06:16 PM
oracle error 904 while attempting to do full db export
im using oracle version 8.0.4 over hpux 10.20...i have created an oracle user x with dba priviledges...upon execution of the exp command
" $ exp x/password full=y file=file.dmp log=exp.log "
i encountered the error listed below:
...exporting table DEF$_AQCALL
exp-00008: ora error 904 enc.
ORA-00904: invalid column name Bus error (coredump)
What could possibly wrong with my db? I want to make a full database export.
Thanks in advance.
regards,
danny
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-17-2002 09:41 PM
тАО11-17-2002 09:41 PM
Re: oracle error 904 while attempting to do full db export
Re-run your catexp.sql as internal user.
$ORACLE_SID=<>
$export ORACLE_SID
$svrmgrl
svrmgr>connect internal
svrmgr>@$ORACLE_HOME/rdbms/admin/catexp.sql
Revert after running the same
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-17-2002 11:02 PM
тАО11-17-2002 11:02 PM
Re: oracle error 904 while attempting to do full db export
I've found an entry on metalink that states that you should drop all the Replication Queue tables before doing a full export (after backing everything up).
I recommend that you raise a tar woth Oracle.
Regards,
John
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-18-2002 12:58 AM
тАО11-18-2002 12:58 AM
Re: oracle error 904 while attempting to do full db export
Try reinstalling the export views by running catexp.sql
SVRMGR> connect internal
SVRMGR> @?/rdbms/admin/catexp.sql
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-18-2002 01:02 AM
тАО11-18-2002 01:02 AM
Re: oracle error 904 while attempting to do full db export
Didn't see that our friend Manikandan had posted the same answer...
Maybe a good idea to read the thread before posting....
Andreas