2
votes
2answers
288 views

Does RMAN in Oracle only copy the archive logs? What happens to the active redo log in case of failure?

If RMAN copy copies the archived redo logs when they are full, what happens to the current redo log in the event of a failure (hardware failure, etc.)? Isn't there always an active redo log that is ...
0
votes
2answers
339 views

How to fetch file path from a folder through PL/SQL

We upload files on our library on weekly basis. I wanted to fetch the latest uploaded file path/URL from a folder through PL/SQL, but not sure if it's possible. If possible, please suggest what ...
2
votes
3answers
123 views

Are these indexes redundant?

I have two indexes on a table that will contain roughly 10-20 million records at a given moment. Index 1 CREATE NONCLUSTERED INDEX [IX_NC_AccountNumber_UTC] ON [dbo].[LogWindow] ( ...
0
votes
1answer
72 views

Extract data for all groups in a single SELECT statement

MySQL 5. Table: schedule Columns: id int(10) UN PK AI startdate date groupid smallint(5) UN The following statement extracts the Schedule ID for a given group (the schedule with the latest date ...
0
votes
1answer
417 views

Incremental MySQL restore using binlogs

I've tried to restore a MySQL database using incremental binlogs and mysqlbinlog tool but I received the following message: ERROR 1666 (HY000) at line 30: Cannot execute statement: impossible to ...
0
votes
2answers
255 views

Query Takes more time in SQL Server 2008

I have a table in SQL Server 2008 with 553,386 rows and every day it is increasing by about 400 rows. Now when I full scan of the table (Select * from) it is taking 23 sec. Is there any solution to ...
-2
votes
1answer
34 views

Is there any way to know all the tables(and/or views, triggers, functions) present in the Oracle 9i database?

I want to know this because, I forgot the name of the table I created Using Oracle 9i Thanking you for your time.
5
votes
1answer
778 views

Why does @@dbts increase after backup/restore?

I have a SQL Server 2005 database, containing some tables which have a Timestamp (or RowVersion) column. I need to know the value of the current timestamp, so I use the following query: SELECT ...
1
vote
1answer
2k views

Can I use a Percona Xtrabackup backup to restore a single table?

I've been playing around with the Xtrabackup tool for a month now, and I got to admit : it is really powerful ! I'm still testing it to backup database servers between 5 and 150 GB and the ...
6
votes
2answers
2k views

Slow SQL Server Database (approx 2TB) - high CPU due to index fragmentation?

I've posted this over at ServerFault but didn't have much luck getting a response. I have a fairly large SQL Server database (~2TB). Most of the data is in one table (~6 billion rows). Two weeks ago ...
0
votes
0answers
34 views

Accessing Database from Slave server

I have an application running in one server eg: My Server's Ip is 192.168.10.10, and I have the MySQL database server in the same machine. The application connects database server as localhost. ...
1
vote
1answer
2k views

MySQL cluster 5.6 doesn't convert invalid TIMESTAMP value to '0000-00-00 00:00:00'?

According to the document: Invalid DATE, DATETIME, or TIMESTAMP values are converted to the “zero” value of the appropriate type ('0000-00-00' or '0000-00-00 00:00:00'). but it doesn't ...
3
votes
1answer
498 views

How to store static list of hashes in MySQL effectively?

Problem: I have a list of pairs (md5_hash, id). I want to store the data in MySQL and I want to make queries like this SELECT id FROM table WHERE md5_hash = <some_hash> The number of pairs ...
5
votes
2answers
4k views

Stored procedures, binlog and SUPER privilege

I tried to create this function on Amazon RDS for MySQL: CREATE FUNCTION GetRootZoneId (zoneId INT) RETURNS INT READS SQL DATA BEGIN DECLARE _id, _parentId INT; SELECT zoneId INTO _parentId; ...
0
votes
1answer
117 views

Database mirroring is limited to an original database

Database mirroring is limited to an original database and how many mirror copies?
0
votes
2answers
99 views

Rebuilding index

I have a transaction database and one of nightly job is to rebuild indexes that followed by a log backup and then shrink the log. Is this safe to do so ? Thanks Antony
0
votes
0answers
74 views

Postgresql. Proxying queries and log them

Is there a way of logging of user queries in Postgresql than writing logs on the server side? A proxy or something like that. Pgbouncer don't logging queries, tsung-recorder log them into xml without ...
0
votes
0answers
4k views

Multi user messaging database design

I'm designing a database for a new project and I'm looking for some feedback on the design before I start to implement. It basically consists of secure messaging system with those abilities : One ...
3
votes
1answer
934 views

Doing a point in time restore with CDC enabled; Possible?

I discovered this week, the hard way, that the database restore options NORECOVERY and KEEP_CDC are mutually exclusive. So, this begs the question. How do you do a database restore, keeping CDC ...
1
vote
1answer
8k views

Mysql: update query with subquery

Hello i need to perform the following query Query update Taxonomy set sourceId = ( select id from TaxonomyMapping a where a.oldId = ( select cm.en_ID from TaxonomyMapping ta ...
1
vote
1answer
336 views

Recover oracle 10g database from old data files

I have an Oracle 10g database. Unfortunately, our machine and system crashed and all the backups and Oracle archive logs, but we have old image copies of our data files and one of the control file ...
0
votes
0answers
145 views

How do I debug an Oracle Linux Diskspace Issue?

I have about 429GB Diskspace allocated to this VM. I see that only 179GB is being used. Now when I try to add a 128GB file I get an I/O error saying I do not have any space left. I need to be able ...
6
votes
6answers
1k views

Move SQL Server 2008 database from machine A to B with no downtime

I got a bit of a problem. I have a SQL Server database in box A which has approximately 60gb of data. I need to move this to a new machine but I cannot have downtime at all. Every second that goes by ...
0
votes
0answers
286 views

The remote copy of database “<DBNAME>” is not related to the local copy of the database

I'm trying to join a secondary DB to my SQL Server 2012 Availability Group following this article: Join a Secondary Database to an Availability Group (SQL Server) When I attempt this the local SQL ...
2
votes
1answer
144 views

Is there any way to use different InnoDB settings for different databases on the same server?

From what i know, this is not possible but i'm surprised its not highly requested feature. I'd love to be able to have one db using InnoDB in ACID compliant mode and another db on the same server used ...
0
votes
2answers
264 views

Query to return fields of distinct values per key

In the process of building a data warehouse we are creating some aggregation tables for a reporting engine. We would like to build a single aggregation table from the fact table that can exist as list ...
3
votes
1answer
1k views

Selecting the highest value in a column?

I am dealing with a table that has 3 columns and I need a way to select the record(s) that matches a certain PrntP_PstnGrpID(s) and is the highest ChldLevel ( The PrntP_PstnGrpID could have multiple ...
2
votes
2answers
2k views

Oracle's UTL_FILE when connected locally or through listener has different behaviour

We have a procedure which creates a CSV file with UTL_FILE. (env is Oracle 11.2.0.1 and RHEL 6.4) Until now, we were storing that CSV file into system oracle (the oracle owner) user home ...
3
votes
2answers
640 views

E/R diagram for sports league database

I am attempting to create a data model for a sports league There are two entities in my domain. The first entity is a Manager and the second is a Team. A Manager has personnel id first name last ...
1
vote
0answers
481 views

bulk insert not working in stored proc when using exec [closed]

We have a SQL Server 2005 database with a stored procedure that needs to do a bulk insert. The query in the stored procedure is defined as such: declare @query nvarchar(max) set @query = N'bulk ...
8
votes
2answers
5k views

Composite Primary Key efficiency as a Foreign Key

I have a table with a Composite Primary key (consisting of 4 columns) which is used to ensure no duplicates are entered into the table. I am now in need of a new table which will need to reference the ...
3
votes
1answer
2k views

How to remove diacritics in computed persisted columns? COLLATE is non-deterministic and cannot be used

I have a function that includes: SELECT @pString = CAST(@pString AS VARCHAR(255)) COLLATE SQL_Latin1_General_Cp1251_CS_AS This is useful, for example, to remove accents in French; for example: ...
3
votes
2answers
682 views

continuously extending a table in SQL Server

We have a large data warehouse database where we continuously get new rows inserted in 5 different tables, at the left-hand side of the b-tree (=at end of the table) This cause a lot of page splits. ...
5
votes
1answer
1k views

TPS too high in PostgreSQL

I created a table: CREATE TABLE foo ( id integer primary key, bar integer NOT NULL ); and inserted one row: INSERT INTO foo (id, bar) VALUES (1, 1); and ran a pgbench of the following ...
4
votes
3answers
553 views

Initializing Transactional Replication From two Different Database Backup

I have two different large Database (200GB for each) which I want to replicate their data to a central database (3rd DB). I followed this link and it was very useful for a single database. But my ...
0
votes
1answer
100 views

Performance: order of tables in joined statement

I have the following SQL statement, running on a SQLite database on a Windows mobile device. SELECT table1.uniqueidentifier1, table1.int1, table1.varchar1, table1.decimal1, table1.decimal2 ...
3
votes
1answer
120 views

How to design database for polymorphic relationships

I have the following scenerio: There are some categories Each category has attributes An attribute could be of free text or collection of options There is a product which is assigned to category ...
1
vote
1answer
341 views

Transaction(s) still alive: How do I find the cause?

I can tell that something is hogging the transaction log on the DB2 for one of our Websphere Commerce installations. Basically I have a burst of transaction log files that are timestamped 5 days ago. ...
3
votes
2answers
7k views

The best MySQL Settings for 32GB RAM on a Dedicated Server

I am worrying about my memory usage as it is reaching more than 90% if I will not restart php-fpm. I have the following configuration on my MySQL: [client] port = 3306 socket = ...
0
votes
1answer
55 views

Can I write a Select query to update the data too

Can I write a Select query under a jdbc connection ,having a resultset object and which would update the records on just passing the select query them in my sql.
0
votes
2answers
6k views

Diffrence between relational and unrelational database [closed]

What is the difference between relational(MySql) and unrelational database(MongoDb)
-2
votes
1answer
326 views

message table schema - body TEXT or varchar [closed]

I want to make a small social network. For messaging body which one is more suitable? VARCHAR or TEXT? if VARCHAR how long is efficient?
1
vote
2answers
16k views

How to see profile assigned to a user

Let's say i have created a user as 'TEST_USER', and then i assigned a profile to it. Now how can i see for TEST_USER which profile has been assigned? I want some query that will check what profile a ...
1
vote
1answer
1k views

Cannot install DB2 Express-C 10.1 on Mac OS X 10.7.5

I'm having troubles seting up DB2 Express-C 10.1 on my Mac OS X (v10.7.5). My initial install attempt failed, but then I found ...
10
votes
7answers
30k views

Why won't PostgreSQL 9.3 start on Ubuntu?

I have successfully installed PostgreSQL 9.3 from the APT repository on 2 VM's running Ubuntu 12.04 and 13.04...however, I cannot get it to install properly on my host machine running Ubuntu 12.04. ...
1
vote
2answers
852 views

MySQL stores BLOB in innodb buffer pool (innodb_buffer_pool_size)?

I have several databases all in INNODB, 50GB are BLOB columns, only 700MB are not BLOB data. Tools as mysqltuner ask me to set innodb_buffer_pool_size = 51GB. Does MySQL store the BLOB in RAM? If ...
1
vote
0answers
22 views

Recover original utf8 data from latin1 mysql db [duplicate]

We forgot to change charsets in our mysql db after migration on new server. Current situation: mysql> show variables like 'character%'; +--------------------------+----------------------------+ | ...
1
vote
2answers
2k views

Transactional Replication: When to delete the initial snapshot

I would like to delete the initial snapshot after I setup transnational replication and everything is working fine. When is it OK to the delete the snapshot that initializes a subscriber?
0
votes
1answer
54 views

Append columns with values from has many reletionship

I have two tables orders and items. Every Order has many Items. orders - id - created_at - paid_at items - id - title - amount - quantity - order_id Let say that there are 3 kinds of items. Chair, ...
0
votes
1answer
251 views

Geography union via cursor returning null

I need to combine multiple geography records into a single entity to store in a spatial data table, but I've learned that the only available function in MSSQL2008R2 that accomplishes this task is ...

15 30 50 per page