I have a table called person setup like this
(person_id SMALLINT UNSIGNED,
ethnicity varchar (...
Background: SQL Server 2008 R2 mirrored and clustered.
We recently failed over the databases via mirror and everything went smoothly. When it was time to do a differential backup, I got an error so I ...
I have a transactional replication set up with initialize from backup.
In the secondary database server,i have a drive(d:) for data files alone.
I have noticed that this drive is getting filled and i ...
I recently upgraded from MySQL 5.7 to 8.0. I have noticed some changes from 5.7 to 8. But I have not been able to find any discussion on following situation that I have been puzzling for a while.
I'm working with a VLDB instance with over 60 DBs and close to 200 DB files, allocated over nearly 20 volumes. The instance is a Dev server getting periodic restores from a production instance with a ...
We usually employ different MySQL versions for different scenarios. And I realized that similar databases, whith the same amount of tables and data, just because of different mysql versions differs in ...
Im using MaridaDB 10, but my question applies to all mysql variants.
I have large dataset (70GB uncomressed when dumped to file).
The mysqldump process takes 2-3hours. The restore process takes even ...
I'm trying add more data into my schema, but I encounter the following error
ORA-01116: error in opening database file 14
ORA-01110: data file 14: '/u01/oracle/oradata/REVA/ra_tbsp07.dbf'
I have a number of files left from a previous Oracle db and I would like to create a new one from the files.
The files include:
16 .dbf files
Could you ...
According to this Oracle document, the maximum number of database files per tablespace is "Operating system dependent; usually 1022".
I know there are queries for some of the other limits mentioned ...