Stack Overflow
Stack Overflow

Questions tagged [database-administration]

The aspects of database usage not directly related to the insertion and extraction of information, such as security, configuration and performance tuning. These questions are OFF-TOPIC FOR STACK OVERFLOW; ask them on dba.stackexchange.com instead.

Note: There is a separate Database Administrators site dealing with database administration. If the programming aspect of your question is only minor, consider posting there.

Database administration is the umbrella term for a wide range of database-related activities, ranging from installation and configuration, to stability monitoring, performance tuning and security auditing.

2087 questions
400
votes
10 answers

How to replace a string in a SQL Server Table Column

I have a table (SQL Sever) which references paths (UNC or otherwise), but now the path is going to change. In the path column, I have many records and I need to change just a portion of the path, but not the entire path. And I need to change the…
Iralda Mitro
  • 7,190
  • 5
  • 24
  • 29
358
votes
15 answers

Difference between a user and a schema in Oracle?

What is the difference between a user and a schema in Oracle?
sengs
  • 6,647
  • 6
  • 30
  • 24
121
votes
6 answers

Cannot drop PostgreSQL role. Error: `cannot be dropped because some objects depend on it`

I was trying to delete PostgreSQL user: DROP USER ryan; I received this error: Error in query: ERROR: role "ryan" cannot be dropped because some objects depend on it DETAIL: privileges for database mydatabase I looked for a solution from these…
notalentgeek
  • 4,939
  • 11
  • 34
  • 53
102
votes
10 answers

Frontend tool to manage H2 database

How to use H2 database's integrated managment frontend? For operations such as create table, alter table, add column, and so on.
blow
  • 12,811
  • 24
  • 75
  • 112
80
votes
3 answers

What are NDF Files?

SQL Server uses .mdf for data files and .ldf for log files, but what are .ndf files? What are the benefits of these files?
Nasser Hadjloo
  • 12,312
  • 15
  • 69
  • 100
64
votes
3 answers

Find out the history of SQL queries

An update SQL query was executed on the server, which caused many problems later. How can I get the list of update queries executed in last 2 months, so that I can trace the exact problematic SQL query?
sumit vedi
  • 757
  • 3
  • 11
  • 17
49
votes
10 answers

improve speed of mysql import

I have large database of 22GB. I used to take backup with mysqldump command in a gzip format. When i extract the gz file it produces the .sql file of 16.2GB When I try to import the database in my local server, it takes approximately 48hrs to…
dharanbro
  • 1,327
  • 4
  • 17
  • 40
36
votes
4 answers

revoke vs deny : what is the difference

What is the difference between the DENY and REVOKE commands in SQL Server?
ceth
  • 44,198
  • 62
  • 180
  • 289
33
votes
8 answers

How do you manage schema upgrades to a production database?

This seems to be an overlooked area that could really use some insight. What are your best practices for: making an upgrade procedure backing out in case of errors syncing code and database changes testing prior to deployment mechanics of…
Mark Harrison
  • 297,451
  • 125
  • 333
  • 465
32
votes
4 answers

Are there any good PostgreSQL clients for linux?

I am frustrated of not having a good Linux GUI administration and development tool for PostgreSQL. pgAdmin III is buggy and unusable piece of... hmm, software, compared to Windows-only PostgreSQL Maestro and EMS PostgreSQL manager. phpPgaAmin does…
senotrusov
  • 799
  • 1
  • 7
  • 7
32
votes
13 answers

How do I resolve this "ORA-01109: database not open" error?

I'm trying to create my own database using SQLPlus. So first I log into it as admin: sqlplus sys/sys_password as sysdba And then I try to create a new user, called sqlzoo : CREATE USER sqlzoo IDENTIFIED BY sqlzoo DEFAULT TABLESPACE…
Caffeinated
  • 11,982
  • 40
  • 122
  • 216
30
votes
10 answers

How can I kill all sessions connecting to my oracle database?

I need to quickly (and forcibly) kill off all external sessions connecting to my oracle database without the supervision of and administrator. I don't want to just lock the database and let the users quit gracefully. How would I script this?
BIBD
  • 15,107
  • 25
  • 85
  • 137
30
votes
4 answers

how to drop partition without dropping data in MySQL?

I have a table like: create table registrations( id int not null auto_increment primary key, name varchar(50), mobile_number varchar(13)) engine=innodb partition by range(id) ( partition p0 values less than (10000), partition p0 values less than…
vidyadhar
  • 3,118
  • 6
  • 22
  • 31
28
votes
2 answers

What's the difference between the Oracle SYS and SYSTEM accounts?

What are the differences between the Oracle SYS and SYSTEM built-in accounts?
Hooloovoo
  • 2,181
  • 3
  • 16
  • 21
25
votes
3 answers

ORA-01658: unable to create INITIAL extent for segment in tablespace TS_DATA

When i tried to create a table in my User_DB schema i am getting an error as ORA-01658: unable to create INITIAL extent for segment in tablespace TS_DATA. I run the following query to get all the TABLESPACE_NAME: SELECT * FROM DBA_DATA_FILES; But i…
Andrew
  • 3,632
  • 24
  • 64
  • 113
1
2 3
…
99 100