0
votes
0answers
6 views

Oracle 11.2 restore DB to a specific point

I should execute following tasks: 1. test system and during test change Oracle data and Create New/Remove Old datafiles and tablespace. 2. at the end of test rollback to behviour before of point 1. ...
0
votes
0answers
3 views

Why connection in sqldeveloper to machine in the same network fails?

I have windows machine with Oracle DB XE 11.2. When I start sqldeveloper on the other machine, windows, use the same credentials an put as hostname ip of machine with DB, sqldevelopr cannot establish ...
0
votes
0answers
6 views

Slow running Oracle query caused by unnecessary full table scan

I'm by no means an expert with Oracle, but I know enough in terms of how to analyze explain plans and perform basic optimizations. However, this time, Oracle has stumped me with it's explain plan. ...
0
votes
0answers
12 views

Kerberos and Linked Server

I have been reading through past posts but I am still getting issues with 2 SQL servers connecting using a linked server when querying from a 3rd SQL server. I constantly get the error "Login failed ...
2
votes
2answers
26 views

Hindrance in TSQL SVF Call

I have a simply Products data table with 100k records (just generates some random data): set nocount on create table dbo.temp_Products ( [ProductID] int, [Type] tinyint, [Price] float, ...
-2
votes
0answers
22 views

Please help on “PostgreSQL installation checklist” [on hold]

This task is regarding developing a shell script on checking-up the PostgreSQL installation. I lack expertise in doing shell scripting. So, can you please help me in developing this task please. ...
0
votes
1answer
13 views

Query issue for login page in asp.net?

I would like to create a simple login page in asp.net. here is my code: protected void Button1_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(); ...
0
votes
0answers
18 views

SQL update multiple columns matching a pattern

I have a table in a postgresql database in which I have multiple columns matching a pattern /\w*(?:_open|_close)/g. Those are timefields. I would like to substract 1 hour from all the rows on those ...
-1
votes
0answers
10 views

What does NoSQL have to offer compared to the filesystem?

Suppose I have a local application, is there any reason to prefer NoSQL over just using the filesystem for get/put operations? Because I cannot think of any thing that could be faster/easier?
0
votes
0answers
19 views

Script to automatically Identify tablespaces above threshold and bring it back to below threshold value

I am facing all the tablespaces crossing threshold problem in all most all the databases we have in our environment. Because of this much manual effort is been needed. I am able to identify the ...
0
votes
0answers
20 views

What will be best (for performance) transaction isolation level?

There, are two types of queries that are executed in my app: DELETE FROM tbl1 WHERE user_id = 1; INSERT INTO tbl1 VALUES (...), (...), ...; and UPDATE tbl2 WHERE id = 1 SET ...; DELETE FROM tbl3 ...
0
votes
1answer
25 views

Stack trace of oracle sql execution

Is there a way to get the stack trace of the SQL query that is given in awr, I mean a way to check the flow of the query from which package or procedure that it has been triggered? tkprof and awr both ...
0
votes
0answers
11 views

Best way to insert html content into clob column in oracle

I want to write a stored procedure to save html content into clob column of a table. sample html text below: <p font style='font-size:12px;' face='Arial'> Last modified: April 30, 2014 (<a ...
-3
votes
0answers
14 views

A Simple replication Code step by step [on hold]

Simple Replication Code to work in Command Prompt. Please explain step by step. I dont have idea .
0
votes
0answers
10 views

Simple Mongo DB replication

I need to get things done, quick and fast and now. Later on, down the road, say in a month or less, or more, I will want to have my database replicated in few more machines. I wonder, if I can ...
0
votes
0answers
7 views

Releasing space after deleting datafiles

I'm deleting old backup tablespaces with option using contents and datafiles in TOAD. Datafiles were deleted, but no space was released: Filesystem GB blocks Free %Used Iused %Iused ...
0
votes
0answers
20 views

lock request time out period exceeded. When revoking db_owner access

I am trying to revoke db_owner access of an user and I am getting this below error! I have no active transactions User (whom I want to revoke access) is not connected to any db DataBase owner is ...
3
votes
2answers
114 views

Have: Postgres database files. Need: Functioning database

I am running Ubuntu 14.04 with a postgres/postgis setup and in a weak moment removed PostgreSQL 9.1 (seemingly a legacy install from 12.04 from before I upgraded to 14.04), having erroneously ...
0
votes
0answers
5 views

Mongodb 3.0.1 in ubuntu starts but status, stop or restart show 'mongo stop/waiting'

I am relatively new to Mongo and have installed 3.0.1 on a Digital Ocean droplet (Ubuntu 14.04 LTS). The database starts without problems but I am unable to 'sudo service mongod [stop/restart/status]' ...
0
votes
0answers
10 views

Multiple Distributors in SQL Server Replication

Per this article, a Publisher can only have one remote Distributor in doing SQL Server Transactional Replication. Each Publisher can be assigned to only a single Distributor instance, but multiple ...
0
votes
1answer
13 views

InnoDB Table has backed up INSERT and UPDATE queries, high CPU

I am running an MySQL DB with all InnoDB tables. I often have many queries backed up for the same table when I run SHOW PROCESSLIST; Basically, I keep a table of every logged in customer and update ...
1
vote
1answer
21 views

Reference column alias in same SELECT list

I'm converting an old MS-Access-based system to PostgreSQL. In Access, fields that were made up in SELECTs could be used as parts of equations for later fields, like this: SELECT samples.id, ...
0
votes
1answer
20 views

Make 3 separate tables, or 1 combined table for similar data?

When designing a database's structure, if we have multiple tables with similar data, should these tables be combined, with an added ENUM field to denote the table type; or should 3 separate tables be ...
1
vote
1answer
35 views

Why do maintenance plans exist as a feature?

Do maintenance plans provide any functionality beyond their component parts? It would seem that the only value added is the convenience of grouping subplans into logical bundles, and the simplified ...
0
votes
2answers
41 views

Query that was working on MySQL is not working on PostgreSQL

I had the following query (with bin_number being a string) which was working on MySQL 5.5: Postgres - was working on MySQL and doesn't work on PostgreSQL SELECT "menu_items".* FROM "menu_items" ...
0
votes
0answers
13 views

Normalization questions with non-real world examples

I have a few questions regarding normalization. I'm aware these may be terrible examples from a practical point of view, but I need to understand how normalization theory applies to them. 1) Table: ...
5
votes
1answer
585 views

SQL Query challenge

I have what seemed like an easy query to write, that really has me stumped - can anyone help me please? So this is really easy on paper, but I can't translate it into SQL. Lets say you have some ...
0
votes
1answer
40 views

Get the latest record and count them with time interval

I have a table as below id fk_sales_id status created_at 1 001 5 2015-02-17 16:45:44 2 001 8 2015-02-18 18:45:44 3 002 30 2015-02-20 16:45:44 ...
0
votes
0answers
18 views

use outer apply to find for each row have a record based on first result from detail table

i have a two table there's PROBLEM for problem (as master) with group of problem and PROBLEM_LOG (as detail) PROBLEM PROBLEM_ID PROBLEM PGROUP 1 Line Down ...
0
votes
0answers
21 views

VACUUM FULL fails with 'ERROR: Check free disk space'

I am using Postgres 9.4. I have a database that \l+ tells me is 164 GB. When I try to run VACUUM FULL on the database, I get this error (after many hours): ERROR: could not extend file ...
-2
votes
1answer
21 views

Prioritised table query

I'm looking for a way to query two tables at once but ... I want the query to first run against Table A and then if Table A returns no matching records to query Table B. There many well be instances ...
0
votes
0answers
18 views

Database design trouble for survey application

I'm having trouble figuring out how to design database tables. I'm going to have a table employees which has the employees' information such as names, age, email, etc. It is going to be an ...
0
votes
0answers
20 views

alter database open - Oracle11g [on hold]

Because of some issues i had faced I'm trying the below query on oracle 11g. But its throwing error. Could anyone please help Query:alter database open ERROR at line 1: ORA-00600: internal error ...
0
votes
0answers
19 views

ORA-01033: ORACLE initialization or shutdown in progress [on hold]

I'm facing the below error while trying to login to database. Oracle services were up and running but was not able to login. Error:ORA-01033: ORACLE initialization or shutdown in progress I tried to ...
0
votes
0answers
17 views

I want to rewrite my MySQL query so that FIND_IN_SET doesn't do a full table scan unless necessary

I want to rewrite my MySQL query so that the last table join doesn't do a full table scan unless necessary. Here's what I mean. Under certain conditions I don't need to select any rows in that join ...
1
vote
1answer
14 views

Postgres: check disk space taken by materialized view?

I know how to check the size of indexes and tables in Postgres (I'm using version 9.4): SELECT relname AS objectname, relkind AS objecttype, reltuples AS "#entries", ...
1
vote
1answer
15 views

Drill Down Functionality for Data Entry in Database

I am building a database that houses financial statement data. Within the database and to maintain the relational model and data integrity the fields are standardized. However, I do not want to lose ...
2
votes
0answers
35 views

SQL “Standard” guide?

I am currently learning TSQL and am learning that were possible, I should use "standard" SQL dialect. Where can I find out which commands are "standard" and which are TSQL?
0
votes
0answers
13 views

Debugging value of varchar set to empty string crashes SSMS?

DECLARE @test varchar(1) = ''; SELECT @test When debugging, hovering over @test displays a little {...} token, and clicking the magnifying glass to open the text visualizer causes an application ...
0
votes
1answer
24 views

sql query for hierarchal search [on hold]

In the below relational table, I want to search all user id's whom are are under any particular sponsorid in hierarchical manner User Id Name Sponsor Id 10030080 TULSI RAM ...
0
votes
0answers
14 views

Is it possible to deploy Microsoft PDW on Azure?

I've read about it and want to play around with it for a bit. I think it requires a minimum of 4-5 machines to run, which is feasible with Azure IaaS, but how do I actually deploy it there?
0
votes
0answers
7 views

Couldn't setup postgresql cluster with heartbeat pgsql ra

I'm trying to install postgresql cluster with the following configuration: 2 virtual hosts with RHEL 6.6 x64: postgresql 9.1 with hot standby replication pacemaker 1.1.12 resource-agents 3.9.6 I ...
1
vote
0answers
21 views

SQL Server 2014 Replication - The process could not connect to Subscriber 'xxx'

I have just set up very basic transactional replication on SQL Server 2014. The Publisher and Distributor are one and the same. I have configured the Publisher to push to the Subscriber, so any and ...
0
votes
0answers
31 views

How can I get a list all Databases in a Database Instance

I am getting an error with SQL Copy Database Wizard. It is finding a database that was dropped over a year ago and fails because it cannot be found. I cannot find any reference to the database and ...
0
votes
0answers
11 views

MySQL Server Install Setup Types Developer Default vs Full

As I'm installing MySQL Server Community Edition the possible Setup Types are: Developer Default Server Only Client Only Full Custom Is there any difference between options Developer Default and ...
-2
votes
1answer
20 views

How to implement a distributed database system [on hold]

I have been tasked to find out how to implement a distributed database system using the various database management software available like: MS Access 2013, MySQL and PostgreSQL. How would I be able ...
0
votes
1answer
31 views

combining two different record into single result

I am fetching data from 3 tables with the help of join. My output is in JSON format. Output in JSON format:- {"order_id":"2", "location_address":"Testing location Delhi", ...
0
votes
0answers
45 views

Optimising an SP - Left Join against several big tables

I have stumbled upon performance bottleneck due to LEFT JOIN against several big tables (approx. 6 million rows of data, consisting of 10 columns). Any suggestions on how to optimize this SP is ...
-2
votes
0answers
27 views

How to restore database? [on hold]

When you save metadata (added new column selection) from the translation of reference issued SQL error message: The log file for database '' is full. Back up the transaction for the database to ...
0
votes
1answer
22 views

How can I drop and create postgresql views in dependency order?

I found the following http://stackoverflow.com/a/9712051/61249 which is good but still too much manual labor for me. I need to recreate the views in the right order how would I go about doing that? ...

15 30 50 per page