Support Gints.

By the way, you do not "convert" storedprocs from SQL Server to Oracle, you learn what the storedproc is supposed to do and you rewrite it from scratch.

The...

Richard -- you are adorable 😀

If you have to pre-create your instance -as I appointed in my posts that means you cannot recover from your exp dump. What part of...

As appointed by previous posts... have you considered to build an index serving your query's predicate?

Here is what I wanted to say... you do not do "select *" in a...

Unfortunately you do not understand Oracle jargon, "logical backup" doesn't mean "valid backup method".

You cannot recover an Oracle database if all you have is an export dump file. Period.

Mazharuddin Ehsan (8/2/2008)

---

I think logical backup and recovery using the exp and imp utilities are also very useful and important as it allows to take backup of selected objets in...

Thanks God I'm not "most people" 😀 I just do whatever pay the...

I've been there, I done that.

1 Brace for impact, keep your poker face no matter what you see.

2 All Oracle documentation is online and free... try http://www.oracle.com/pls/db102/portal.all_books

3 Subscribe...

Okay... here we go with some info about Oracle backups.

COLD BACKUP

Usually database is in noarchivlog mode; no point in time recovery.

You shutdown your database then you copy -operating system copy...

Sometimes desperate situations require desperate solutions.

Here is a crazy idea.

Imagine you have to archve and purge all rows where flag=1 while you have to keep rows where flag has any...

Nice!

Would you consider to run a Server Side Trace and check where time is wasted?

You have to populate a table using the output of that query, just run the process once a day and you will end up with one row per object per...

Chances are query takes time because it's just a dog.

Is offending query performance getting worst over time or it just sucks from day one?

I suppose the value of that Flag column changes over time, isn't it?... heavy updating?

By default PKs are clustered. Either way a clustered index is actually part of your base table which enforces the physical order in which data is stored. You can have...