mmhh... are you talking about version control of system objects?

Matt (4/27/2009)

---

Today My website started running very slowly and in many cases timed out before the sql statement could complete, I restarted the SQL server instance and found that everything...

...why I'm having troubles to digest this statement?

Your options are :

1) Sit tight and wait...

What is your SQL Server version?

Alex Rosa (4/25/2009)

---

opss...I guess the information above is not correct.

It's possible to create more than one DATAFILE...

Check http://support.microsoft.com/kb/307487 ... this is why I love Microsoft's KB

:w00t: shocking!

... sorry, couldn't help myself 😀

http://www.dbasupport.com/forums/forumdisplay.php?f=20 😉

tempdb database is actually rebuilt by SQL Server at startup time; message suggests space needed to build it is not available on your storage subsystem.

Make the required amount of...

Assuming you are talking about promoting...

This doesn't sounds like a "Working with Oracle" kind of question.

Eitherway -not considering the merits of the exercise - you can join both tables, load all columns of each row...

I'm not that familiar with Oracle express interface.

I would set the proper ORACLE_HOME and ORACLE_SID then open a SQLplus session and do it in one shot.

It shouldn't fail; my wild guess is that the batch file has some bad character, look:

oracle [6]:

oracle [6]: cat createtable.sql

CREATE TABLE "TEST45" (ID NUMBER(5,0) NOT NULL ENABLE, DUMMY VARCHAR2(10), CONSTRAINT...

Just a couple of questions to better picture the scenario.

1- Is this happening on a well configured database server or is it happening on a desktop/laptop?

2- What can you see...

Usually they are poorly dressed, nervous, don't look you in the eye and just run away when they see a DBA patrol car approaching...