1
vote
0answers
82 views

In SQL Server sp_cursorprepare/sp_cursorexecute run extremely slowly

I'm running an application (Pentaho user console with the Saiku Ad-hoc plugin) which creates a query and runs it using sp_cursorprepare & sp_cursorexecute standard stored procedures. My model is ...
0
votes
1answer
902 views

ORA-30009: Not enough memory for CONNECT BY operation

I have a Linux VM (with CentOS 64 bit) where I installed Oracle Database 11g Express Edition. The database is running, I can use sqlplus and I can create tables and stuff. However, when I run a ...
1
vote
1answer
535 views

Oracle silent install on Redhat Linux (The Global database name was left blank.)

I am installing Oracle 11g in silent mode using the response file that is in the database/response directory. It is three response files in that directory(i.e. dbca.rsp, db_install.rsp and netca.rsp). ...
0
votes
1answer
117 views

How to install postgresql on a server? [closed]

Background: I am busy with an MSc in GIS. It involves using postgresql 9.2 with the postgis extension as the spatial database and QGIS to view, edit and analyse the data. I know postgis is also ...
1
vote
2answers
234 views

What useful information can I get from ASH report which I cannot get from AWR report?

What useful information can I get from ASH report which I cannot get from AWR report? What are the common scenarios in which its better to get information from ASH than from AWR?
0
votes
1answer
80 views

Ask about Inner Join & Union

i want to ask about my script this is doesn't work. i need to help ! SELECT A.*,B.mat_nama,C.mats_nama FROM pengeluaran AS A INNER JOIN(material AS B) ON(A.mat_id = B.mat_id) INNER JOIN(mat_satuan ...
6
votes
3answers
15k views

Converting XML to MySQL tables

I have a large XML file in the following format and I need to convert this file into a MySQL table. Please let me know how can I accomplish this? ~~~~~~~~~~ <host starttime="1392325468" ...
3
votes
2answers
3k views

What is a good way to copy data from one Cassandra ColumnFamily to another on the same Keyspace (like SQL's INSERT INTO)?

Trying to find a way to easily transfer all the rows from a Cassandra ColumnFamily/Table to another. The COPY command, as I understand, is a good option. However, as it dumps all the data to .csv on ...
2
votes
1answer
389 views

Can I configure MySQL replication to break when I run a “drop database” or “drop table” command on the master?

Basically, what the title says. This would enhance the failover quality of our systems, becuase we have run into issues of people thinking that they were in a test environment running drop statements ...
1
vote
0answers
551 views

SQL Server Configuration Manager 2012 - TCP/IP, unable to set IP All = No

I have a 4-node SQL Server 2012 SP1 cluster, and under Network Configuration -> TCP/IP -> Protocol (tab), I am able to switch Listen All from Yes to No. However, when I hit OK (or Apply), I get the ...
0
votes
1answer
74 views

How to structure a database to show data for each USA State and Canada Territory on a Per user basis?

I need to build a PHP/MySQL application. I am a bit confused on how to do the database for a project like I am about to explain though. The end result will be a Map of the USA and Canada. Each ...
0
votes
0answers
914 views

Oracle error: UDI-00018: Data Pump client is incompatible with database version 11.01.00.06.00

I'm trying to use data pump to move the database to a different server with this command: impdp dbuser/dbpsw@dbserver directory=data_pump_dir network_link=sourceDB schemas=EMP But I got this error: ...
1
vote
1answer
535 views

Restore postgres data/tablespace to new tablespace (at new mount point)?

I have a bunch of test/development databases which we currently refresh with production data as-needed using a NetApp filer's snapshot capabilities - we have a production slave with its datadir on a ...
7
votes
1answer
2k views

MATCH FULL vs MATCH SIMPLE

I've noticed a MATCH SIMPLE or MATCH FULL option in phpPgAdmin, but I can't find a description in the docs. How do they function? The default is set to MATCH SIMPLE.
3
votes
1answer
1k views

How can I search SQL Server for maintenance plans that execute specific tasks?

Sometimes certain SQL Server maintenance plan tasks can be problematic, like Shrink Database, Rebuild Index, Update Statistics, etc. I'd like to search for the use of one or more of these tasks on an ...
0
votes
1answer
191 views

Digital content eCommerce schema advice? [closed]

I don't have much experience designing databases, I'm looking for some advice on my design from more seasoned designers/developers. I'm developing a digital content eCommerce store which will be ...
0
votes
1answer
405 views

SUM a new value to an existing value

I have a php script which processes a form with a single input. I want the value I send through input to be added to an existing value in database (mysql). For example in database I have value = 10 ...
1
vote
2answers
136 views

Does this medical database look correct?

I'm pretty new to databases and I'm trying to create some schemas. I've been working away at this one for a while, but I can't help feeling that it doesn't look right. Essentially I have the ...
2
votes
1answer
70 views

Get results ordered by a specific column in a looping way

I have heavy difficulties in getting rows ordered in an special way. Two tables are part in this: Table 1 - WORDS: id | char | word | categoryid (<- id of a row in CATEGORY) Table 2 - CATEGORY: ...
2
votes
2answers
836 views

Bad bind variable in audit trail trigger in Oracle 11g R2

I have been trying to construct audit trail triggers and procedures in oracle and I am facing a problem with bind variables. Following is the code create or replace trigger trg_audit_trail for insert ...
21
votes
2answers
2k views

Why does query error with empty result set in SQL Server 2012?

When running the following queries in MS SQL Server 2012 the second query fails but not the first. Also, when run without the where clauses both queries will fail. I am at a loss why either would fail ...
0
votes
0answers
58 views

Do link servers cache remote database connections?

I have set up a link server from a database server (SQL2008) to my local SQLEXPRESS db, using the actual database as its Failover Partner. I then stopped the SQLEXPRESS service and I could still ...
2
votes
1answer
537 views

How to allow connections to SQL Server with 2 differents ip

I have a small issue here: I have a SQL Server instance 2012 (let's call it INSTANCE) on a cluster. I also have 2 network interfaces for this instance: SQLINSTANCE.my.metwork ...
0
votes
1answer
283 views

How to automatically Reset Query Cache for improve table cache hit in MySQL?

I have a VPS running CentOS 6.4 and 2.5GB RAM, Intel(R) Xeon(R) CPU. Its MySQL version is Server version: 5.5.35-cell. I have two active wordpress sites and two inactive sites (inactive sites use for ...
0
votes
1answer
513 views

What is a bucket in database? [closed]

I was implementing a code that involves a database and buckets. Just wanted to ask what is bucket and can someone describe it with an example? Thanks!
0
votes
0answers
22 views

row locking with innodb [duplicate]

What is the most efficient way to lock a specific row for within a mysql transaction. I am currently using for update using select is there another method that im unaware of? if not are mysql locks ...
1
vote
1answer
69 views

mysql multiple database prioritize innodb buffer pool size

With a mysql instance and multiple databases within that instance is there a way to allocate which database you would like to assign priority to the buffer pool size?
0
votes
1answer
85 views

MySQL: What points should we consider when create composite index

There are multiple views behind the logic of creating composite index in a table. Creating composite index is obvious when we have composite primary key. Beside this, we create composite index on the ...
0
votes
1answer
90 views

What index(es) should I use for three columns join?

I have a table which has the following columns: CREATE TABLE example ( exid INT, extype INT, studentid INT, (more columns) ) The table will have hundreds of thousands rows, and each ...
2
votes
2answers
6k views

Script to see running jobs in SQL Server with Job Start Time

how to write script to see running jobs in SQL Server with Job Start Time? SELECT sj.name, sja.run_requested_date, CONVERT(VARCHAR(12), sja.stop_execution_date-sja.start_execution_date, 114) ...
0
votes
1answer
397 views

converting varchar to number while passing to IN clause

I am really stuck here.. Given below is the miniature of what I am trying to achieve. set serveroutput on; declare rajesh varchar2(20); x number(10); begin select wm_concat(stocks_id) into rajesh ...
0
votes
1answer
696 views

High rise in Aborted_connects on mysql slave servers

I have a MYSQL replication set up where I have a single master and three slave DBs. The slave DBs are load balanced behind a Zeus Load Balancer. I can see on slave DB servers that the ...
0
votes
0answers
90 views

MySQL - Index on VARCHAR Column with less cardinality

We have huge data in day wise partition with each partition carries some 20Million rows and some 120 partitions. Now, on table we have one NAME - VARCHAR(100) column and each partition contains some ...
1
vote
1answer
76 views

Import (imp) not showing final report stats/results

I'm trying to execute an import of a dmp file an not obtaining the final results of the import. It's really weird because i obtained really big files (nohup.out and imp_xxx.log) with the following ...
2
votes
1answer
2k views

ORA-29339: tablespace block size 16384 does not match configured block sizes

My box is RHEL 6.2, and file system BLOCK SIZE is 1024. # tune2fs -l /dev/sda1 ... Block size: 1024 ... My Oracle is 11g, and database block size is 8192. SQL> show parameters ...
0
votes
2answers
12k views

How to Create users in sql server for accessing only one database using Management Studio [closed]

How to Create users in sql server 2008 R2 for accessing only one database using Management Studio. regards, salman
0
votes
3answers
376 views

How to IFNULL or COALESCE rewrite in a SQL query?

I there a way to rewrite a SQL query, so I can avoid IFNULL or COALESCE, because the HXTT DBF JDBC driver (supports SQL92) throws the following error.: Caused by: java.sql.SQLException: The aggregate ...
1
vote
1answer
70 views

Oracle - Date of Selection on table

how to get last date when someone perform selection on table? Last accessed in terms of select statement only not last updated date
0
votes
1answer
4k views

Oracle installation requires old rpm versions, what to do?

I am installing Oracle 11g R2 on OEL6. I run the following command, for to check only prerequisites ./runInstaller -silent -responseFile /0/grid/response/crs_install_mk.rsp -executePrereqs It ...
1
vote
1answer
775 views

Exporting from Oracle enterprise edition to standard edition reaches schemas limit

So, I'm trying to export an oracle database(10.2) from EE to SE over a networklink. It all works fine except that I'm hitting a limit. The database has 1335 schemas and it seems that I can't transfers ...
1
vote
1answer
309 views

DB Locks - How would one handle long transactions and maintain high concurrency?

We're maintaining a POS/WMS Application built in powerbuilder that runs on SQL Server 2008 R2 backend. Recently, we've been having a lot of locking issues and I believe it has to do with how we handle ...
0
votes
1answer
151 views

Initializing values to a custom data type

I have defined a custom data type which I need to use in my procedure. Give below is my data type. CREATE or REPLACE TYPE CUSTOM_DATATYPE AS object( chkinvpre VARCHAR2(100), orderid ...
4
votes
3answers
275 views

Backup & recovery strategies for Partitioned Database in Sybase ASE

I need to know about backup & recovery strategies for partitioned Database in Sybase ASE 15.7 . I am not worried about transaction failure & recovery scenarios We have already faced this 2 ...
0
votes
1answer
324 views

why mysql binlog creating new log file daily

I have started binary logging on MySQL server on my Ubuntu. It start creating log files in /var/log/mysql. My my.cnf configuration is as follows: log-bin="/var/log/mysql/" expire_logs_days=10 ...
2
votes
3answers
271 views

How can I safeguard against SQL injection where parameterizing my query is not an option?

I'm working with ESRI's arcpy module, and I need to specify a WHERE clause as a parameter to this function. Since the result will eventually be used to retrieve data from the database, the text of the ...
1
vote
1answer
1k views

Postgres replication: Do I need to rsync pg_xlog files if I have archiving setup in master?

I am trying to replicate a master to slave, without shutting down my master. In the tutorial here: http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial, they recommend these steps: ...
0
votes
1answer
575 views

MySQL warnings while loading integer data into table (SOLVED)

For some reason, after loading a large amount of data into the following table (from a single file), all of the values register as 0. CREATE TABLE secondTable ( freq int NULL, w1 int NULL, w2 int ...
0
votes
0answers
25 views

Impact of additional int field as primary key

Directly to the point, at one time I have a table like this: create table item( item_id varchar(50), constraint pk_item1 primary key (item_id) } However from my discussion one day, there is ...
0
votes
0answers
38 views

I need advise on if I should rebuild my index [duplicate]

I have a SQL Server 2008 Standard server on full mirror (safety). I reorganize all indexes weekly. I am looking into rebuilding a few indexes to improve performance. I ran DBCC SHOWCONTIG on my ...
0
votes
0answers
300 views

PostGres- How to loop in Table to update every record in Table

I am working on complicated problem, but I will simplify it to this problem. I have two tables A [ID, column1, column2, column3] B [ID, column1, column2, column3, column4] and i want to update the ...

15 30 50 per page