I am attempting to create an Index on one of my tables. I keep getting "operation timed out". Why is this?

I am setting up a disaster recovery box for the production website. For this, I took a backup of the production MS SQL database and restored it into the DR box.

When I run the application, I get an access denied message. I checked the database and I found that the user mapping is gone!

How do I restore it ?

How to group data by month when using a date time column in MySQL? I want to produce a report, to group the results by month. The table has a column for which the data type is DateTime. How to use it, to get the results by month?

Hi,

I have a big table in Access containing some records. I need to export them to Oracle database running on the same machine.

The table has only 3 fields. Transaction ID, Customer, Salesman.

How do I send them to Oracle? Do I need to create a table there or something like that? I do not know Oracle. 

Is there any simple way to do so? I played around Office 2007, export option but the closest I could get was to export to a text file. My friend said that you can also use this text file as an input in Oracle. But it sounds confusing. 

Hi,

Hi,

I have a user created in Oracle by the name "joseph". The initial table space was named as "tspjoseph" which used a data file named "josephtsp.dbf". Unfortunately, I set the size to 1GB which is not full filling the requirement. My whole software is up and the database is also filled with important data. Is there any way I can increase it, without affecting the current data?

Hi,

I am using Oracle to learn SQL. Just introductory. I downloaded the Oracle setup file from Oracle's homepage named – "oracleXE 10g". The software installed successfully, but I don't seem to find the user Scott, which was used in the class lecture. I missed the lecture so could not figure out if there was anything said which was not covered in the papers. I asked a partner who said it was a default user. Then why can't I access it? Do I need a configuration or something to be set up at the beginning? Or am I using the wrong version? The instructor said in the paper that it was 10g, are there any variance within 10g?

I have a Database at my store. Unfortunately, I want to add new column to one of my tables. What I am thinking is to use the command DELETE TABLE and replace it with a new one but I want to save time editing and filling again the data.

Is there a way to just insert a new column which could not affect or change my stored data? Please help. Here is the data in my table. 

I want to clear my concepts about the semantic object views in databases. Can anyone guide me in detail? I am waiting for the experts to respond.

Dear all,

I'm using MS Access 2003. I have a large database with lots of information. I can input data in MS Access but I don't know how to make a compiled report. Most importantly, I want to make a report with the exact requirements that I need in my report.

Please let me know if anyone has any instructions which will be most helpful for me. Thanks.

Labu