- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- ORA-00604
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
тАО01-30-2007 01:15 AM
тАО01-30-2007 01:15 AM
ORA-00604
we meet a problem when running:
connect system/manager
/
alter tablespace $tbs offline $alter_option;
/
drop tablespace $tbs including contents cascade constraints;
/
alter system checkpoint;
We meet the error:
ORA-00604: error occurred at recursiveSQL level 1
What's the cause???
thanks
Enrico
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-30-2007 01:17 AM
тАО01-30-2007 01:17 AM
Re: ORA-00604
http://ora-00604.ora-code.com/
http://orafaq.com/forum/t/21841/2/
http://searchoracle.techtarget.com/originalContent/0,289142,sid41_gci933283,00.html
http://oracle.ittoolbox.com/groups/technical-functional/oracle-dev-l/oracle-error-ora00604-383250
Google provides good resources on this one.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-30-2007 01:29 AM
тАО01-30-2007 01:29 AM
Re: ORA-00604
next error on the stack is:
ORA-01555: snapshot too old: rollback segment number 2 with name "R01" too small
Enrico
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-30-2007 02:41 AM
тАО01-30-2007 02:41 AM
Re: ORA-00604
Have a look at this - http://www.cryer.co.uk/brian/oracle/ORA01555.htm
You could try increasing the size of the rollback segment or adding more.
Rgds,
Peter
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-30-2007 05:36 AM
тАО01-30-2007 05:36 AM
Re: ORA-00604
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-30-2007 05:48 AM
тАО01-30-2007 05:48 AM
Re: ORA-00604
ORA-604:
it is a hidden bug.Pls try following;
1. Stop all application server processes, including OPMN:
opmnctl stopall
2. Change $LANG:
unset LANG
- or -
LANG=en_US.ISO-8859-1; export LANG
3. Start up application server processes again:
opmnctl startall
Note that in $LANG charset names are different than in $NLS_LANG, because $LANG uses IANA names for character sets, e.g.
IANA Name: ISO-8859-1 ISO-8859-15 WINDOWS-1252
Oracle Name: WE8ISO8859P1 WE8ISO8859P15 WE8MSWIN1252
regards;
mustafa
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-30-2007 05:53 AM
тАО01-30-2007 05:53 AM
Re: ORA-00604
regards;
mustafa
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-30-2007 09:31 PM
тАО01-30-2007 09:31 PM
Re: ORA-00604
How can I drop a tablespace without saving the undo informations in the redo logs?
I cannot find the drop syntax.
thanks
Enrico
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-30-2007 09:44 PM
тАО01-30-2007 09:44 PM
Re: ORA-00604
I can't think of a drop tablespace option that truncates the tablespace.
I can however think of a way to get around your problem.
Simply truncate all tables before you drop the tablespace and ensure no transactions are running.
Truncate does not keep redo.
If you want syntax or script how to quickly generate truncate script for your tables let me know okay.
Good luck:)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-30-2007 09:51 PM
тАО01-30-2007 09:51 PM
Re: ORA-00604
Thanks
Enrico