Questions tagged [datafile]
The datafile tag has no usage guidance.
136
questions
-1
votes
1
answer
56
views
How to load data into a table from a file and set other column(s) too?
I have a table with multiple columns. And there's also a text file which contains data, one value per line:
aaa
bbb
ccc
ddd
How would I load a file into a file into a certain column as well as set ...
- 35
0
votes
1
answer
36
views
Can database administrators access and modify the database before it's opened?
I'm trying to answer the following question (asked in a previous exam and supposedly having one correct answer):
To create a DATAFILE and Assign it to a DATABASE, the instance can't be
started in ...
- 131
1
vote
1
answer
81
views
InnoDB - how MySQL InnoDB pages works with underlying OS file system
I've studied and summarized how MySQL InnoDB pages works with underlying OS file system when accessing secondary storage.
Would you mind to confirm that my understanding is correct?
InnoDB store ...
- 113
0
votes
1
answer
301
views
Change default location for Oracle datafiles
I wanted to change the default location for Oracle datafiles and spread data across different physical drives using below command. This way u02, u03, u04, u05, ... will automatically point to ...
- 3
0
votes
1
answer
192
views
Oracle Data Guard - Wrong Path with new created Data Files
I've created a Standby Database with the following duplicate command:
run {
duplicate target database for standby from active database
spfile
parameter_value_convert 'ORCL','ORCLSTBY'
set db_name='...
- 3
4
votes
3
answers
1k
views
How to recover from a SQL server log file drive crash?
Assuming data files are on D: and Log files are on E:
Say the E drive crashes and the log files (.ldf) are lost. I attach a new empty disk to the E: and start the sql server.
Upon startup, SQL Server ...
- 3,360
0
votes
1
answer
156
views
Oracle 11gR2 (11.2.0.4.0) - Drop and Remove Datafiles
We have a database of 2000 users.
We will drop all remaining schemas, leaving only 2 end users, excluding Internal (Oracle maintained) users.
After this operation, there will be a very high reduction ...
- 29
0
votes
1
answer
58
views
Production filesystem is at 100%. Move the datafiles to a new filesystem?
As the title states our file system reached 100% capacity and I want to try moving the tablespaces datafiles to a new filesystem. I'm attempting to follow the steps from this link:
http://www.dba-...
- 11
0
votes
2
answers
604
views
Why is it not important whether data and log files share the same disk or not in a SAN? [closed]
I have a hard disk. I create 3 drives on it. One for OS. One for sql data files. One for sql log files.
However I am reading that suppose my storage layer is not a hard disk, but a SAN based ...
- 3,360
0
votes
2
answers
95
views
Oracle: Corrupt datafile will not turn back online?
need immediate assistance on an issue... Oracle Support is taking way too long to respond back on.
We have a corrupt datafile in one of our tablespaces, I attempted to shut the datafile offline, and ...
- 11
0
votes
2
answers
1k
views
ORA-01652 - unable to extend TEMP segment?
Having an issue that I can't seem to find any solutions to online.
[72000][1652] ORA-01652: unable to extend temp segment by 256 in tablespace TEMP Position: 581
One of our users runs a query ...
- 11
-1
votes
1
answer
198
views
Move logship database file
I want to move a ldf file from one drive to another. Some idiot who is definitly not me restored the log file to the wrong drive which is nearly full now.
The database is readonly/standby for a ...
- 79
0
votes
1
answer
480
views
SQL Server data drive (.mdf files) running out of space
We have a D drive that has 999 GB of total space. Currently the production database data files are being stored there. It is running out of space.
A few weeks ago DB files were shrunk to temporarily ...
- 83
0
votes
0
answers
182
views
How to open .bin SQL database?
I'm stuck and not sure if somebody had a similar issue.
I have an old database stored as .bin files. It dates back to 2012. I can see an xml catalogue file which indicates to me that it is some kind ...
- 1
0
votes
1
answer
26
views
how to restrict usage of datafile in Oracle
We have several datafiles with a big amount of a free space.
How to shrink those files on production system. I tried to move all objects from this files into another tablespace, but RDBMS is still ...
- 421
0
votes
1
answer
136
views
Postgres's equivalent for Oracle's datafile recovery
In oracle, one can do a recovery from datafiles.
Does Postgres have an equivalent procedure?
I am already aware of the WAL files in Postgres, but I believe this is different. Datafiles in Oracle are ...
- 321
1
vote
0
answers
70
views
Naming a datafile with spaces in the name
I would like to know if there could be a problem when naming a datafile with spaces in the name, I have an Oracle 11gR2 database, using ASM as storage, a datafile was created, belonging to an ...
- 149
-1
votes
1
answer
228
views
unable to open database because of corrupt file
when ever i try to open my database i get an error saying
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01147: SYSTEM tablespace file 13 is offline
ORA-01110: data file 13: '/...
2
votes
2
answers
2k
views
SQL Database size incorrect and database file growing while empty
RESOLVED - SOLUTION AT BOTTOM OF POST
PROBLEM
I have a database data file showing as 200GB on disk, and 200GB allocated space in the database properties. sp_spaceused also shows 200GB allocated. All ...
0
votes
0
answers
356
views
SQL Server File or Filegroup Creation Date
Is there a way to find out when a File was added to a filegroup in SQL Server. Or how to determine when a filegroup was created?
I've tried querying the sys tables looking at the lsn information and ...
1
vote
1
answer
25
views
re size datafile oracle
thanks for reading.
I am currently working with an Oracle 11G.I have a problem with a tablespace, I have very little space left, and I need to increase its capacity.I know what to do with this ...
- 125
2
votes
1
answer
955
views
DBCC ShrinkFile EmptyFile fails due to system table SYSFILES1
In following a recommendation from our new storage vendor, I'm trying to split up some large & busy databases into multiple data files, each to live on a separate VDisk that has a separate ...
- 794
1
vote
1
answer
124
views
65G SQL Server database has 5.5G of data in tempdb when not in use
I have a SQL Server instance with 1 production database (also ReportServer dbs) that is 65G. tempdb is 5.5G (well, actually much bigger but 5.5G is in use) when server is not in use. I believe this ...
- 11
0
votes
0
answers
709
views
Word file running an SQL command - How do I find the source SQL database?
A word 2013 file has a merge function that activates whenever this is open and it is "SELECT * FROM 'database'".
As the final results have errors (the final word document feeds from the wrong field ...
- 13
-1
votes
3
answers
11k
views
Oracle data file size
My client’s tablespaces are autoextend off and i add monthly or bimonthly 3 or 6 gb space for tablespaces.
Can you advise me if there is a recommended datafile size for Oracle 11gR2 on Windows 64 Bits?...
0
votes
1
answer
223
views
Multiple mdf, empty one is missing
Hi guys i have a big problem. I know i did such stupid and unforgivable mistake.
And know please help me if you can.
I wanted to make copy of database. I should make it by backup and then restore as ...
1
vote
1
answer
292
views
How to recreate Oracle db from .ora and .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:
init_locdb.ora
16 .dbf files
spfilelocdb.ora
log files
.ctl
Could you ...
Pavel
0
votes
1
answer
156
views
Bulk Import appending the data to the data file
We have a bulk import task running in SQL Server 2016 which imports more than 5 million rows. The task itself is configured at cloud using third party services. The strange thing is that the new data ...
- 23
1
vote
0
answers
96
views
Transactional Replication and distribution database size
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 ...
- 1,295
0
votes
1
answer
103
views
What is a good practice for storing unstructured tables as a field in mongodb
Context:
I am developing an application that requires handling tables that do not necessarily have an uniform structure (eg. different/extra columns). Those unstructured files also need to be grouped ...
- 101
0
votes
2
answers
116
views
Considerable size difference between mysql versions
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 ...
1
vote
0
answers
390
views
MySQL 8 more than doubles the size of MyISAM table after optimization
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 ...
- 21
2
votes
3
answers
1k
views
Creating/restoring mdf/ldf to non-default file location giving access denied
Default folder is typical C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA. But C: drive on server is almost full.
So, in restoring an 11gb database from another server, I ...
- 121
0
votes
2
answers
387
views
Max DATAFILE size in NDB engine
My database setup is using NDB cluster with 2-3 nodes, on CentOS. While trying to test out the performance, i tried to store ~7mil records (around 2GB size) into one of the table. at around ~200k, it ...
- 13
1
vote
2
answers
3k
views
Migrating Postgres server from Windows to Linux
Simple question: I want to migrate all of a Postgres server's data, schema, roles, everything from Windows to Linux.
Can I just copy the contents of the %PGDATA% directory in Windows to which the ...
- 344
1
vote
1
answer
2k
views
How to refresh Oracle data dictionary to remove deleted tablespace and datafiles?
Long story short we have a server with two Oracle instances running on it: ora1 and ora2. Somebody defined an undo tablespace for ora2 and provided the same datafile of the undo tablespace datafile of ...
- 131
0
votes
0
answers
55
views
Does splitting 1 tempdb file into 4 require a SQL Server restart? [duplicate]
please can anyone help?
I have a SQL 2008R2 instance with 4 cores, configured with 1 tempdb data file and 1 logfile.
I want to change this setup as per best practices by adding 3 additional euqally ...
- 39
1
vote
2
answers
938
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 ...
- 19
2
votes
1
answer
97
views
How Database Formats Files for Disk
This SO answer outlines how MySQL organizes its database into files, but doesn't describe the structure of the files themselves.
I am wondering, at the physical level, how relational database ...
- 187
1
vote
5
answers
9k
views
TABLESPACE creation error
I have an error "ORA-01537" when I create a tablespace.
create tablespace "VOLUMT" datafile 'VOLUMT.dbf' size 250M autoextend on;
Then, it shows like following.
ERROR at line 1: ORA-01537: cannot ...
- 97
2
votes
1
answer
924
views
Disk Architecture on SQL Server [closed]
I am building a new environment using the SQL Server 2017 Always-On system.
This will be active 24/7 and there will be lots of DML processes.
I have a 100GB SAS for the OS, a 1TB SAS for Data and a ...
- 58
5
votes
1
answer
223
views
Difficulty removing files from filegroup
I am trying to delete all files from my database from an unused filegroup. There are two files totaling aroun 1.5TB.
I can see that there is now approx 400mb still in these files but I cant see what ...
- 189
2
votes
1
answer
338
views
SQL Server on Linux: Allocation unit on ext4
I'm testing SQL Server on Linux and now on the following point:
Allocation Unit Size of the partition: I learned at SQL Server on Windows the Allocation Unit Size (sector size) must be 64K because of ...
- 33
10
votes
2
answers
8k
views
How to Move TempDB Files to a Different Drive or Folder? [duplicate]
How do I move my TempDB Data or Log File(s) from wherever they are now to a different Drive or Folder?
- 1,524
5
votes
2
answers
716
views
SQL Server: Identifying object closest to the end of a datafile
TL\DR
I'm looking for a way to efficiently identify the object located closest to the end of a SQL Server data file. This approach needs to remain performant against large data files.
What I have ...
- 9,282
2
votes
2
answers
2k
views
Backup and Restore SQL server files and filegroups
I have a database called Admin. It has only one default filegroup called primary.
File group: primary
files in the file group: Admin_data.mdf
Now I have taken a full filegroup backup.
Backup file ...
- 1,900
1
vote
2
answers
152
views
mysqldump file restore while sql is still being dumped
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 ...
- 11
3
votes
1
answer
4k
views
DBCC SHRINKFILE for Log and Data when using Availability Groups
We had an issue where one of our database tables grew by 40GB by mistake. The database is part of an Availability Group with one primary and two replicas. While trying to delete the extra records we ...
- 1,003
2
votes
1
answer
1k
views
Mysql cannot import from text file
I have a table called person setup like this
(person_id SMALLINT UNSIGNED,
fname varchar(20),
lname varchar(20),
gender enum('M','F'),
birth_date date,
race enum('B','W','A','J'),
ethnicity varchar (...
- 21
4
votes
1
answer
3k
views
Two SQL Server databases share the same MDF and LDF files but have different data [closed]
I have a strange circumstance where I have a production database and a restored copy as another database on the same SQL Server instance, and both of them are using the same MDF and LDF files (i.e. ...
- 143