Invalid Objects but no errors

I checked for invalid objects and two of them came up. When I tried to recompile them it says there was compilation errors. Yet show errors doesn't show anything. Does anyone have familiarity with this particular package or have an idea on how to fix this so it is valid? SYS

catrepad - how tell if run

How can you tell if catrepad.sql has already been run on a database? I am sure that catrep has already been run, but not catrepad. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric Richmon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Replication - snaphot/asynchronous

I read that any given object can be in only one replication group. We already have SNAPSHOT replication running from Server A to Server B. Now we want to set up ASYNCHRONOUS replication to run from Server A to Server C. How can that be set up so there isn't a conflict if the objects can only be

Character Sets - 2 different kinds, same server

Is it possible to have two different databases on the same server using two different kinds of character sets (one would be UTF8 NCHAR and the other would be US7ASCII)? How do you create the databases with two different character sets (is it an init parameter)? If that is not possible and

trigger - need help writing

When detail_comments in the testable is inserted or updated too then I want it to update the various_comments column which is in the same table (testtable). What would be the most efficient way to write the trigger to do this? CREATE OR REPLACE TRIGGER ADD_TO_TESTTABLE AFTER INSERT OR UPDATE

OS authentication

I want to use OS authentication. On the server side (Windows2000), does the user need to be created as OPS$USERNAME or just USERNAME? For authentication, do they need to be added to any other group besides User? Is there anything else that needs to be done for authentication to work? In the

Oracle 9i and BLAST

Has anyone worked with 9i in combination with BLAST? Just looking for feedback positive and/or negative. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric Richmon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

NLS_DATE_FORMAT

On NT/2000, how can you set the NLS date format at the session level? Isn't there a file that you can set it in? What do you write in the file? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric Richmon INET: [EMAIL PROTECTED] Fat City Network Services--

dbbackup_begin Velpuri script

If anyone has the dbbackup_begin script from the Velpuri book/website that they are currently using and it is working properly, can you please send me a copy? I would really appreciate seeing an example that is definitely working. I realize that RMAN is available, but the person that I am

Velpuri bkup script-syntax error

Did anyone else run into the error dbbackup_begin: syntax error at line 521 'end of file' unexpected after trying to use the Velpuri backup scripts for Unix? Where was the problem at and how did you resolve it? I downloaded the scripts from the Osborne website and this is the error that keeps

Hot Backup scripts UNIX

I am looking for a hot backup script that has been successfully used on UNIX(Solaris). Wouldn't mind using the Velpuri scripts, but they seem a bit complicated and we have had some issues trying to actually implement them. Would really appreciate seeing what other people are using. Also would

Notification of failed backup

Does anyone have a script (or some method) that works on NT to send an email to someone if a backup failed? There are two types of backups currently running including an export and hot backup. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric Richmon INET: