Check this out ...If you still have the issue

http://x220.win2ktest.com/forum/topic.asp?TOPIC_ID=5435

Mike

From the OS I will do a backup and restore.

Especially if the location of the datafiles

and log files are the same

Mike

It seems to me that if you map a drive

it will appear as local a drive.

This is something you could test if you have a test system

Mike

You sure can.I am sure the documentation that comes with the CDs will have what you need

Mike

Oracle has a lot more configurations to play with and parameters that could be watched than sql server i.e it is not as self tuning.

Try to have as much hands...

I enjoyed SQL server 2000 Perf Tuning a Technical reference by Whalen, Garcia, Deluca Thompson inter alia.

One other way is to read the recommendations from amazon.com barnes and noble...

Try sp_help "table_name"

Mike

Are you pegged 24/7?

If not you could do a dbcc checkdb in the wee hours

Mike

That is something you may want to check with whoever administers your NT domain...

Mike

Maintenance plans are executed by the agent do you think that could have anything to do?

Does the job run normally when scheduled?

Right click on DB and choose full backup...

From my experience...

I am not sure you can just copy a database online and be able to attach it.

1)Take the db offline or shut it down or sp_detach

2)Copy your files...

I think openview might be able to do that on the strength of what I have seen it do.

Manytimes you define your alerts and thresholds for openview to use.We

configured...

Thank you .I would think about letting them create users too and documenting that

Mike

You mean print out the tables in a schema and the relationships if any?

Mike

May be missing something.

You are attaching as completely new database which should not exist right?

If so then the database does not exist error

does not seem to make too much sense...