0
votes
0answers
17 views

How to ensure on Oracle RAC One Node that the OWB control service is started on the active node after a planned relocate or unexpected fail-over? [duplicate]

I followed the document 'How To Install a Warehouse Builder 11g Repository on a RAC' (Doc ID 1571166.1) to set up the OWB repository (11.2.0.4) on my Oracle RAC One Node system. Because it's a RAC One ...
0
votes
0answers
9 views

Does data guard support Oracle Warehouse Builder?

Does data guard support Oracle Warehouse Builder (both 11.2.0.4)? If not, what is the procedure to setup/configure my OWB project (repository, workspace, control center service...) on the standby ...
0
votes
1answer
28 views

What is the difference between Primary key and Super key in DBMS

I am new to DBMS and I am still learning the theory. I am getting really confused with this key business and after googling I have narrowed it down to just 2 keys I dont get (primary and super key) ...
0
votes
1answer
30 views

Can I use mysql/mariadb databases on different OS?

If I will use mysql/mariadb on Windows and soon I'll decide to switch to Linux or vice versa, can I use databases created in one operating system in another one without any data-loss? Thanks in ...
-1
votes
0answers
22 views

Arrange Rows Data into columns [on hold]

I am facing one issue of arranging data from rows to columns, i have to remove rows depending on LeaseType (i.e:- Plate Glass or Business Interupption and show it in columns, how to achieve this ? ...
3
votes
2answers
70 views

How to inner join some tables and outer join others?

I'm certain I'm going to be embarrassed by the eventual answer, but I've been googling around and banging my head against the wall and can't figure it out. I have four tables described below. I'm ...
3
votes
1answer
49 views

Very large btree index with few rows (openstreetmap gis data)

I tried to import a subset of open street map data to a Postgres database using the standard tool (osm2pgsql). I then tried to rebuild the indices on the table using plain sql (dropping them, then ...
0
votes
1answer
45 views

Inserting data into multiple tables

For my system, students are required to create a user account by completing a registration form (personal, contact and course details; also username and password). I need to collect registration data ...
0
votes
2answers
32 views

MS Access .mdb & .ldb database corrupted

I am using a A.mdb database. You know when connecting the database Microsoft automatically create a .ldb file. Unfortunately my pc shutdown when connecting the database. As a result after restart the ...
-3
votes
2answers
35 views

SQL Server Management Studio does not load [on hold]

I am working on SQL Server 2012 for the past 15 days it was working perfectly but now I am having an issue: Cannot find one or more components. Please reinstall the application
1
vote
1answer
19 views

Explain PostgreSql ssl_cipher values: ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH

In the postgresql.conf file, one can configure authorized values for ssl_cipher. Yet I could not find documentation explaining what the ALL, ADH, LOW, EXP, MD5 and STRENGTH values correspond to. MD5 ...
0
votes
2answers
32 views

Sql statement to compare two table

I have two table with the same structure, i want an sql statement to compare them and see any modified line, deleted or added Table Product1 : ________________ |Product | Price| |Product1 | 10 | ...
1
vote
1answer
29 views

unable to import the file

Gone through the below link also but i am unable to import CSV file in mysql. Even i had tried by using > LOAD DATA LOCAL INFILE but same error persisting. Please help me in this. queries i tried had ...
0
votes
1answer
37 views

select multiple columns group by one with inner join

I have a problem with group by, i wanna select multiple column but group by only one column these below code which is i am used but its given a error. SELECT ...
0
votes
1answer
19 views

How many tables will be there in Magento 1.8 [on hold]

I just started using Magento with 1500 products and I saw the DB size is about 150MB and when I looked at the tables, the count is 250 tables. Is it normal? Should I worry about anything? I host ...
0
votes
1answer
14 views

How to disable HTML output in mysql console?

I've used several mysql instances on many servers, but this one had a suprise for me tonight when I tried to use its console for the first time : me@MYSERVER:~$ mysql -H my_base (....) (...) Server ...
1
vote
2answers
26 views

Perform group by with random group expression (randomly partitioning rows) MYSQL

Let's say I have a table (with millions of rows) cat1|cat2|value A | B| 10 ... and I want to group the data by cat1 and also split the grouping into 10 (at least roughly) equal partitions of ...
1
vote
2answers
47 views

What subquery do I need to calculate this report?

I have two tables: tickets and comments. I need to run a report that shows me which ticket is "neglected" meaning that there has not been a comment in X amount of time. If I was to do this in PHP, I ...
0
votes
2answers
32 views

Building a dedicated physical MySQL server [on hold]

I have a database that I use to mine a "primary" 20-column table with 18 million rows and growing by about 2 million a week, and that may accelerate. I am working to pre-process data by running PHP ...
0
votes
1answer
23 views

Perl - MySQL/MariaDB - slow with no identifiable bottleneck

I am running a Perl script (using DBI) which reads from raw files from a hard disk, and updates MySQL database (which is on a separate SSD). My performance is rather slow (1000 files processed in ...
0
votes
2answers
21 views

MySQL query performance question

I have a MySQL database where I would like to return results based on multiple rows. id | key | value | selector --------------------------------------------------------- 1 | username ...
0
votes
0answers
9 views

When there is a Type 1 and type 2 SCD in a dimension table, how are updates to the type 1 column handled after the type 2 column is updated?

Eg: ID Type1SCD Type2SCD FromDate todate 1000 100 ABC 01-JUL-2014 NULL Now, Type2SCD is updated ID Type1SCD Type2SCD FromDate todate 1000 100 ABC 01-JUL-2014 12-JUL-2014 ...
0
votes
0answers
15 views

LDAP authentication with Percona Server

Reading over this post it seemed to indicate this plugin allowed user authentication via LDAP Percona Server is bundled with the PAM plugin which opens a plethora of ways to authenticate to ...
0
votes
2answers
32 views

Using a join to return multiple values of the same column?

I have two tables user Rank In the Rank table, I saved rank_id and supervisor_id. In the Rank table, I stored the rank name. The rank_id and supervisor_id are foreign keys from the Rank table. ...
0
votes
1answer
45 views

SQL SELECT - adding field to SELECT with JOIN is changing the results

I have a SQL sentence with JOIN, running on mysql 5.5.16: SELECT DISTINCT (ot.orders_id), ot.value FROM orders_status_history osh INNER JOIN orders_total ot ON ( osh.orders_id = ot.orders_id ) WHERE ...
0
votes
0answers
6 views

Missing “NEW” Button for Creating a new Table in OLE DB Destination Editor ( SSIS package designer)

Is there any way to get the missing "NEW" button for creating a new table in OLE DB Destination editor? I was trying to create a Data Flow task in my package that reads from a source table and writes ...
2
votes
1answer
52 views

SQL Server 2008R2 convert collation

I have an existing database that uses the Arabic_CI_AS collation, but I need to convert it to SQL_Latin1_General_CP1_CI_AS the default collation for the server, but the problem is when I use the ...
1
vote
1answer
25 views

Tuning Mongo (TokuMX) for fastest bulk reads

What options do I have for tuning MongoDB / TokuMX for reading the results of queries with large result sets? I'm currently on a single server (no sharding) with the data on an SSD drive. My queries ...
1
vote
2answers
33 views

How to insert values into a table from two different tables?

I have three tables students table ------------------------------------ id(PK, A_I) | student_name | nationality teachers table ------------------------------------ id(PK, A_I) | teacher_name ...
1
vote
1answer
34 views

pass data from deleted table to another

This is the situation: I have a table, with name TABLE_1 I would like delete TABLE_1 and then create another table with the same name and some of its columns. TABLE_1 has records, but I need to pass ...
0
votes
1answer
26 views

Move Commonly-Repeated Fields into a new Table

I'm still at the design stage for a new system, and I've noticed there are several places where different types of object share similar fields. In this case, we have customers, offices, warehouses ...
0
votes
0answers
4 views

pt-archiver and foreign keys?

How does pt-archiver handle foreign keys? Does it archive associated data? (seems not but the documentation is not very clear to me) And if not, how could one perform an archive of a table with all ...
2
votes
0answers
31 views

How do I pass a parameter in a stored procedure to call a DTS package

I have created a DTS package which fetches data from a text file into a database table. I want to pass the file name dynamically from which it fetches data. Can I pass the filename dynamically?
0
votes
1answer
31 views

Auto refreshing a query

I have a SQL statement update test_1 set `t_mark` = (`mark_1` + `mark_2` + `mark_3`) which works perfectly but I want the same statement to repeat automatically when a new row is added.
0
votes
0answers
14 views

Got error with lookup transformation in sql server 2005 BIDS

I have query to seperate the current and history DB's ** select , year(doj) from source where year(doj)<=(year(getdate())-3)* Here the moved data(<=2011) from current DB should be deleted and ...
0
votes
1answer
42 views

ORA-00933: SQL command not properly ended

I have created a database link to a remote database, MIGRERDOSSIER.US.ORACLE.COM, then I use it to insert records in a table in a local database. Here is the request I am trying to execute: insert ...
0
votes
0answers
13 views

full text index not being updated

I have a table that has a full text index defined on it. Change tracking is set to 'Automatic' but I can see that 'Table Full-Text Pending Changes' is set to '58429', and recently added rows (for the ...
0
votes
1answer
29 views

Tools for migration from MySQL to PostgreSQL [on hold]

I have been trying with RazoSQL, mysql2pgsql and dbconvert. But none of this worked fine for me.
0
votes
0answers
25 views

Package body created with compilation errors [on hold]

I run it in sql*plus but always get this message: Warning: Package created with compilation errors. CREATE OR REPLACE PACKAGE BODY Admission_pkg IS ID_Var Tbl_Dept_Info.Dept_Id%type; ...
1
vote
0answers
9 views

firebird update very slow

I am writing a stored procedure for Firebird 2.5 in which I sometimes need to update a single row in a data table more than once in the same transaction. However, I have noticed that the performance ...
0
votes
2answers
62 views

Open Transaction that won't go away SPID Ns

There is a transaction that has been open on this instance since it was restarted and is preventing us from clearing the ldf. Here is the transaction information: Transaction information for ...
2
votes
2answers
52 views

MySQL 5.6: Slave_IO thread stops working

Standard replication breaks for no apparent reason. mysql> SELECT @@version, @@version_comment; +---------------+----------------------------------------------------------------------------+ | ...
0
votes
1answer
26 views

PostgreSQL: How to list the comments attached to a database

How do I display the comments associated with a database, not a table? I've tried \dd and \list , but can't seem to find this. Thanks,
0
votes
0answers
27 views

What's causing Postgres to freeze?

I'm using Amazon RDS to run my Postgres database, v9.3.3. Recently, I had 2 instances where updating the schema caused the database to stop responding and I had to restart it in order to put the site ...
0
votes
1answer
16 views

Date format on the output of cmdshell dir C:\ /TC

I would like to ask you guys if anyone of you had this trouble before. In SQL I read the create time of the file like exec master.dbo.xp_cmdshell 'dir C:\ /TC' which gives me; 07/14/2009 04:20 ...
1
vote
1answer
38 views

Single row to multiple rows with column combination

I have a table like this: ╔═════╦═══════╦════╦════╦═════╦═════╦═════╦═════╦════╦════╗ ║ ZIP ║ STATE ║ F ║ C ║ F1 ║ c1 ║ f2 ║ c2 ║ f3 ║ c3 ║ ...
-1
votes
1answer
32 views

Btree index and Bit Map Index [duplicate]

Please clarify the difference between BitMap Index and Btree index. I am using mysql version 5.5.37-0ubuntu0.12.04.1. I can able to create Btree index but unable to create the same, Please find the ...
2
votes
2answers
76 views

Way to do MERGE with update source when target not match?

I am trying to write a stored procedure that will take new values from a temp table, merge them into an actual table, giving me the ids of the inserted rows, and the rows that already exist matching ...
0
votes
0answers
33 views

performance questions in database design

I need to describe a set of studies that are practiced to a patient, every patient have a "Clinical History", that are described in another table called "Clinical History Lines"(hclines) Every visit ...
0
votes
0answers
6 views

Problems with PostgreSQL and ESRI Geoportal Installation on CentOS

I am installing geoportal 1.2.4 on CentOS from the command line terminal...during my installation I am receiving a fatal ident error message for my user geoportal. The pg_hba.conf file has been ...

15 30 50 per page