The discipline of Operational and Architectural Management of Database Systems.

learn more… | top users | synonyms

0
votes
0answers
365 views

Firebird-Time Interval- between 2 Dates

I try to select the period of employment for the members in a Company. Example: Date of join: 01.01.2001 Today: 27.02.2014 Now, I want this: 13 years, 1 month and 27 days I have a Statement which ...
0
votes
0answers
10 views

Tables not created in default tablespace postgresql

I have create a database with default tablespace 'TEST1' instead of pg_default. the owner of the database and the tablespace is postgres. I log in to the database with postgres -d test create a table ...
0
votes
0answers
55 views

SQL Server A network-related or instance-specific error

I have a windows service that performs a lot of hits to database. Sometimes the database connection is down and I got exception "A network-related or instance-specific error". I got this behavior on ...
0
votes
0answers
63 views

InnoDB crashes frequently

My Innodb Engine is getting crashed frequently. I could not find the reason behind this. This is the error log: 140129 9:22:49 [Note] Plugin 'FEDERATED' is disabled. 140129 9:22:49 InnoDB: The ...
0
votes
0answers
175 views

Can't connect to local Postgres databases

After trying to install Postgres using Postgres.app and EnterpriseDB, I decided to re-install it using Homebrew (As I got some problems connecting to database). PYTHON=/usr/local/bin/python brew ...
0
votes
0answers
21 views

ALTER TABLE Switch Statement Failed due to ANSI_PADDING [duplicate]

I trying to switch table partitions from LEFT to RIGHT. After the required tables have been created, I run the actual switch, but get the following error : ALTER TABLE SWITCH statement failed ...
0
votes
0answers
9 views

Multiple requests shut down MySQL [duplicate]

I have some problems with my MySQL database. I configured a server with the database and other services (apache, php) and put run multiple applications. There are two problems: Every day at the ...
0
votes
0answers
55 views

Best practices for ranking records in flexible way

Suppose we have 10000 records of any product. User search on our website with his given criteria. so we output search results based on given criteria. Now Admin want to rank products in search. so ...
0
votes
2answers
64 views

Mysql 5.5.25 must be restarted to connect

We have MySQL v5.5.25 running on Windows Server 2008 R2. Occasionally people are unable to connect, and the only way we have found to fix this is to restart the mysql service. This happens every 2-3 ...
0
votes
0answers
47 views

Which queries are running and what tables are they accessing? [duplicate]

I am learning Oracle. I am trying to write a query to find out the list of SQL queries and the tables that they access. I tried looking into v$sql, v$sqlarea etc, but was not able to find a column ...
0
votes
0answers
166 views

See list of queries executed by a user in Oracle

As an Admin I would like to see the list of queries executed by a particular user? How can I configure DB to keep track of all the queries executed and how can I see them? I am using Oracle 10g.
0
votes
0answers
35 views

How to install SQL Server 2008 R2 [closed]

My installation is completed, but no instance in not loading (I am on my service account). Show only .in for more browser. Not loading my instance in the database engine. Everything is completely ...
0
votes
0answers
81 views

Can maintenance plans be used in SQL Server multiserver (Master-Target servers) administration?

Since I failed to configure SQL Server 2012 Multiserver (Master and Target Servers) administration, I am eager to understand whether it (setting Master and Target servers) would permit to send from ...
0
votes
0answers
540 views

How to debug problems with SQL Server multiserver (Master and Target server) administration?

I've tried to set Mater and Target Servers on various cobinations of SQL Servers 2012 R2 on Window Server 2008 R2 and Windows 7 machines but always getting one or 2 of the following errors during ...
0
votes
0answers
26 views

Create a schema like an existing schema [duplicate]

I have a existing schema in my database called SCOTT, how can I create a new schema with exactly the same privileges which SCOTT schema is having? Is there any create like or some command to create ...
0
votes
0answers
180 views

Drupal database doesn't work after MySQL restart

I've installed Drupal 7x on my local XAMPP 1.8.3 Server. Everything went fine but after adding some modules, changing the drupal theme and restarting the MySQL Server, the MySQL Server is dropping ...
0
votes
0answers
22 views

Joining data from 2 different servers

It is possible to host my databases on 2 different servers? For example if I store my comments on 'heroku' and store users on some other server it is possible to join the two servers together?
0
votes
1answer
175 views

Error while opening Oracle 11g Database

I have a problem with oracle 11g database, I have shutdown my computer this morning normally, but in the evening when I tried to connect to my database I fond a problem. I cannot connect as normal ...
0
votes
0answers
32 views

PostgresPlus advanced server replication testing issue

I made the replication on my Windows Server 2003 system as master DB and another XP system for slave DB. I just made the configuration, but I don't know how to check the replication of database. I ...
0
votes
1answer
774 views

Table is marked as crashed and should be repaired

I have MySQL and Nagios installed Linux PC (Centos5.5) I have wrote some script to fetch the data from Nagios to Mysql DB (Exactly fetch data in Table) The data fetching working properly (confirmed ...
0
votes
0answers
316 views

How much RAM for a large database on a dedicated MySQL InnoDB server?

Hereunder my hardware config: CPU: 1x Intel Xeon X3470 Quad core @ 2.93GHz RAM: 4x 8GB DDR3 Disks: 2 x SATA 320GB for the system & 4 x SAS 300GB for the DB I've upgraded from 12Gb to 32Gb and ...
0
votes
1answer
111 views

InnoDB Failure of some kind

I have MySQL 5.5 installed. I tried to install Joolma but it failed. I went into their sql and replace EGNINE=InnoDB with MyISAM and the install worked. InnoDB is listed under SHOW ENGINES; Any idea ...
0
votes
0answers
69 views

Linked server performace issue?

I have created a linked server in sql server 2008 R2 Enterprise Edition for mysql i.e. MySQL database is accessible under sql server environment. I have a created a trigger in sql server such that ...
0
votes
0answers
346 views

DBA group in Linux

When we need to install Oracle database in Linux then the user should be in dba group. What is this group and why the user should be in this group for installing Oracle database. What happens if the ...
0
votes
1answer
743 views

“connectivity libraries needed are not found” error in IBM Data Studio

UPDATE I am getting the following error when I try to create a new database in IBM Data Studio v3.1.1.0. The connectivity libraries that are needed for local or remote non-JDBC operations were not ...
0
votes
0answers
1k views

Achieve log transfer to standby (Data Guard)

I am not able to transfer my archive logs from primary to standby. I executed the following query: archive log list Database log mode Archive ...
0
votes
1answer
202 views

Patients profiles database

I am making software for patients in hospitals. I want to make an option that if a doctor has prescribed a drug that interacts with another drug that the patient already uses, a warning will appear ...
-1
votes
1answer
259 views

How can I detect which indexes are being rebuilt offline and how long?

The rebuild of indexes takes appr. the same 55 min. with both "Do not rebuild indexes and "Rebuild indexes offline" "For index types that do not support index rebuilds" with "Keep index online while ...
-1
votes
1answer
73 views

Can I make that connection?

If I have a column with data type varchar(max) in a table that contains a big piece of text, can I make a connection between a word or a sentence in that text with another word or a sentence in ...
-1
votes
3answers
163 views

Recovering Oracle Database using RMAN [closed]

I am an accidental DBA..I have to restore an oracle database using RMAN utility. I don't know anything about backups and restoration and this is my first assigned task. Are there any good forum(s) ...
-1
votes
1answer
187 views

How to merge data from 2 databases [duplicate]

I have a SQL-Server database that crashed while I was away on vacation. All info from 5/2/13 is missing from our current database because my replacement implemented a back-up of the database from ...
-1
votes
1answer
31 views

prepare stmt is not working

set @sqlt = concat("select", @rowname_date," from syslog_data.syslogs_index_1 "); prepare stmt from @sqlt; execute stmt; deallocate prepare stmt; gives me a eeror 1064 in the prepare statement? Any ...
-1
votes
1answer
795 views

What exactly is SOLR? [closed]

It seems like a magical technology that can Do spatial search do full text search The problem is, It doesn't say where does it store all the data. Does it have it's own proprietary database If it ...
-1
votes
1answer
968 views

Difference in between HAS MANY and BELONGS TO in Yii framework [closed]

I am new to the Yii Framework. I discovered HAS MANY and BELONGS TO in the documentation, however I am confused about these features. Can someone give some real life examples with a diagram that ...
-1
votes
2answers
1k views

Data Base Administration Oracle vs MySql? [closed]

I have worked with MSSQL for a while now, but now we want to try to move to some open source for a specific part of the company's products or explore Oracle if possible. What would you say are the ...
-1
votes
2answers
39 views

How is SQL used from an end-user perspective? [on hold]

So I've been learning database manipulation and design and using SQL, but surely a secretary of a company wouldn't be using SQL to directly enter things into the database, so how does that work? For ...
-1
votes
1answer
5k views

IO Error: The Network Adapter could not establish the connection - with Oracle 11gR2. Connecting with SQL developer

I have installed Oracle 11g ON a RedHat6 linux instance, by following all the steps mentioned in "http://technologylair.net/2013/08/oracle-11g-installation-linux/#comment-50" I am trying to connect to ...
-2
votes
6answers
703 views

Missing import function in SQL Developer like MS Access has

At my work we used to use MS Access now we are forced to use SQL developer to create queries and export the data. Details: We can only query to the database We cannot create a new database We use ...
-2
votes
0answers
18 views

increasing Mysql DB Size and Server Size [closed]

I have installed xampp on my windows machine, i'm using MySQL, How to increase the size of mysql server and databases in it? Kindly help me..! Thanks in advance...!!!?
-3
votes
1answer
1k views

Single query to copy data from 3 tables into a single empty table

In an interview today, I was asked if I could write a single query to copy data from 3 source tables to an empty destination table. I started saying "I will use a temp table or table variables", ...
-4
votes
1answer
59 views

When you type an SQL query in interpreter, what does happen? [closed]

Actully this question is asked in an interview from me . When you type an SQL query in interpreter, what does happen? How is the query processed?
-4
votes
1answer
119 views

recommendations needed in order to become a junior DBA [closed]

I want to start off work being a junior DBA very soon. At the moment I have a Bsc in ICT 2:2 but my database marks was very strong including an 86 in my oracle assessment which is following a ...
-4
votes
1answer
107 views

Advice for designing a complex/multipart application [closed]

I'm designing a software application for my medical carrier. It is very complicated, with many parts and many small details. Some experts advised me to divide it to parts, then design the database ...