Questions tagged [alter-database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
19 views

Altering Tables using Tablenames from other Table

I have a database with several tables and i have a table which contains all tablenames which I want to alter. I want to perform a query like this: ALTER TABLE (SELECT "TABLE_NAME" FROM "...
1
vote
2answers
281 views

Where are my files?

The DBA run a file relocation script to move the physical Database file from where it was running to I:. ALTER DATABASE [cro01] MODIFY FILE ( name=cro01,filename=N'i:\SQLData\cro01.MDF') He take ...
0
votes
1answer
71 views

Moving DataFile to Another Location ORACLE

I'm having some problems moving DATAFILE from one location to another due to the shortage of storage space. I've managed to change the path file of control file via command(linux). Now I would like to ...
0
votes
1answer
177 views

ALTER DATABASE ARITHABORT configuration minimum privilege needed

What is the minimum privilege needed to execute ALTER DATABASE {db_name} SET ARITHABORT ON? I found that the privilege ALTER ANY DATABASE would suffice this, but I wonder if there isn't any other "...
0
votes
2answers
153 views

Is using the rename database feature in PHPMyAdmin safe?

I know the rename database functionality has been taken out of MySQL. My question is, does renaming it in PHPMyAdmin work and is safe? I know they have written functionality to deal with a number of ...
-1
votes
2answers
4k views

How do I add multiple users to a role in one statement?

I simply want to add multiple users that I have created to a created role then grant all privileges on said role. This is what I have thus far: CREATE USER Bob FROM LOGIN Bob; CREATE USER ...
0
votes
0answers
42 views

Why are schema changes I've made reverting?

I have been experiencing issues when making schema changes/stored proc definition changes. The changes that I make are not always persistent. I can make a change today then a day or two later I'll ...
6
votes
2answers
945 views

Are cursors/While loops the only way to make administrative changes to multiple databases?

I specifically want a programmable way to change the recovery model of all the databases on a server, and i know this solution can be applied to all 'Alter Database' commands. While I know SMO in ...
1
vote
2answers
103 views

Can't change _log database physical location in SQL Server

I just installed Microsoft ServiceBus and it created 5 databases. Now I want to move them to some specific location so I can join them to SQL Server AlwaysOn Availability group. I stopped service bus ...
1
vote
2answers
649 views

Issues with setting a global setting in PostgreSQL 9.5/PostGIS2.2

I am trying to set a global setting/GUC variable postgis.gdal_enabled_drivers from the PostGIS extension for a while. I am a non-admin user but can ask admin to change settings if needed. But I tried ...
2
votes
2answers
6k views

User cannot create schema in PostgresSQL database

I'm trying to setup a "deployment" user which can create and alter tables on an existing database in addition to selecting, updating, inserting and deleting records. Here is what I've tried so far: -...
11
votes
2answers
3k views

Unable to mirror a database SQL Server 2012

When trying to mirror a database using the following command ALTER AVAILABILITY GROUP SQLAlwaysonGroup ADD DATABASE test0916aj8CJ I get the following error Msg 1475, Level 16, State 105, Line 1 ...
0
votes
2answers
2k views

Drop datafile without dropping a tablespace in Oracle 11g

I was trying to take backup of database in Oracle 11g by using RMAN $ rman target / Recovery Manager: Release 11.2.0.1.0 - Production on Fri Sep 11 10:14:37 2015 Copyright (c) 1982, ...
0
votes
1answer
73 views

database not opening

While altering a DB to open getting the below error. SQL> alter database open; alter database open * ERROR at line 1: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [...
-1
votes
1answer
883 views

Does the scope for 'Alter Any Database' operate similar to 'Create Any Database'?

Does the scope for 'Alter Any Database' operate similar to 'Create Any Database', as in, only those databases created by Login-A under the 'Create Any Database' umbrella can be altered, and not the ...
2
votes
0answers
28 views

Trouble renaming a PostgreSQL database [duplicate]

Trying to rename a postgres database: $ psql -d some_other_database some_other_database=# ALTER DATABASE myapp_development RENAME TO myapp_development_old some_other_database-# \l ...
0
votes
2answers
94 views

Can I update only the needed changes in a database?

First of all, I apologize if you can't understand very well what I am saying and it can be edit for better understanding of my post. The next example is for better understanding of databases with ...
3
votes
1answer
462 views

Could 'Maximum Server Memory' be too low for large batched delete with captured output?

I'm trying to improve the performance of a SQL server database backup program that will create a new database to hold one years worth of report records, delete report records out of the main database, ...
1
vote
1answer
9k views

Tablespace resize in Oracle 10g

I'm trying to resize a couple of tablespaces but the following query is only valid in Oracle 11g. alter tablespace 2 DATAFILE '/appli2/oracle/xxx/oradata02/xxx_undo_01.dbf' resize 3g; In oracle ...
17
votes
5answers
11k views

Move multiple databases from C: to D: at once

I have SQL Server 2008 R2 with 323 databases consuming some 14 GB on my C: drive, a fast SSD. Because I want to reclaim some space on my C: drive, I would like to move them to my D: drive. I have ...