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

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.

1779 questions
379
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
  • 6,738
  • 5
  • 22
  • 29
95
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
  • 11,391
  • 23
  • 66
  • 104
56
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
  • 677
  • 2
  • 11
  • 17
53
votes
4 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
  • 2,843
  • 7
  • 28
  • 39
46
votes
9 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,248
  • 1
  • 16
  • 35
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
  • 267,774
  • 112
  • 308
  • 434
31
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
  • 769
  • 1
  • 7
  • 7
29
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
  • 14,299
  • 24
  • 78
  • 130
27
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? Edit: Apart from 3 letters!
Hooloovoo
  • 2,081
  • 3
  • 16
  • 21
27
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
  • 2,918
  • 6
  • 18
  • 29
22
votes
11 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
  • 10,270
  • 37
  • 107
  • 197
21
votes
13 answers

how to drop database

i used the following sytanx drop database filmo; and got the following error: ERROR 1010 (HY000): Error dropping database (can't rmdir './filmo/', errno: 17) any ideas..
devang
  • 4,067
  • 7
  • 19
  • 11
21
votes
1 answer

MongoDB Single Document size limit is 16MB

Known Information: Its is know that MongoDB stores in BSON (Binary JSON) and the maximum BSON document size is 16MB. Question: Why 16MB itself why not 32MB or 64MB or still more and where exactly the limit has been put for 16MB and what are the…
Amol M Kulkarni
  • 19,000
  • 32
  • 110
  • 158
20
votes
5 answers

How do I find the last time that a PostgreSQL database has been updated?

I am working with a postgreSQL database that gets updated in batches. I need to know when the last time that the database (or a table in the database)has been updated or modified, either will do. I saw that someone on the postgeSQL forum had…
WolfmanDragon
  • 7,505
  • 14
  • 47
  • 58
20
votes
1 answer

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
  • 2,942
  • 17
  • 49
  • 91
1
2 3
…
99 100