Questions tagged [datafile]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer
16 views

In MS Studio how to SELECT from an existing SQL file

I have a complicated query that select parts from an MRP table using several different criteria. The output of the query is a list of parts which includes the key field [PartNum]. I have saved this ...
TonyG614's user avatar
1 vote
1 answer
94 views

Database file reserved space

What are the possible reasons that a SQL Server database file reserved space is 95 percent of the total space? My database file has increased drastically and it shows that the actual space used is 5 ...
LearningSQL's user avatar
0 votes
0 answers
16 views

Restoring PDBs on a new server

I am trying to restore a 19c database on a new server using RMAN. What are the prerequisites? Do I have to first create PDBs which are supposed to be restored? Or should I just restore from ...
datascinalyst's user avatar
-1 votes
1 answer
137 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 ...
Camila326's user avatar
0 votes
1 answer
42 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 ...
Mehdi Charife's user avatar
1 vote
1 answer
112 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 ...
obanadingyo's user avatar
0 votes
1 answer
679 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 ...
geopark's user avatar
0 votes
1 answer
327 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='...
msak85's user avatar
  • 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 ...
variable's user avatar
  • 3,533
0 votes
1 answer
206 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 ...
jrdba123's user avatar
0 votes
1 answer
62 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-...
Phillip's user avatar
  • 11
0 votes
2 answers
765 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 ...
variable's user avatar
  • 3,533
0 votes
2 answers
114 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 ...
Phillip's user avatar
  • 11
0 votes
2 answers
2k 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 ...
Phillip's user avatar
  • 11
-1 votes
1 answer
229 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 ...
user189695's user avatar
0 votes
1 answer
527 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 ...
sqllover2020's user avatar
0 votes
0 answers
233 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 ...
Ali Nato's user avatar
0 votes
1 answer
27 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 ...
Mikhail Aksenov's user avatar
0 votes
1 answer
152 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 ...
J86's user avatar
  • 321
1 vote
0 answers
85 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 ...
miguel ramires's user avatar
-1 votes
1 answer
278 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: '/...
xzgtrtprmwteaghbai's user avatar
2 votes
2 answers
3k 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 ...
Chris Williams's user avatar
0 votes
0 answers
403 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 ...
user210084's user avatar
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 ...
Omar Noa's user avatar
  • 125
2 votes
1 answer
1k 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 ...
NateJ's user avatar
  • 804
1 vote
1 answer
133 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 ...
Mary Opdahl's user avatar
0 votes
0 answers
757 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 ...
Geo_explorer's user avatar
-1 votes
3 answers
12k 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?...
Hedi Fourati's user avatar
0 votes
1 answer
239 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 ...
user3590388's user avatar
1 vote
1 answer
309 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 ...
user avatar
0 votes
1 answer
165 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 ...
NOOK's user avatar
  • 23
1 vote
0 answers
108 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 ...
user9516827's user avatar
  • 1,305
0 votes
1 answer
105 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 ...
ozgeneral's user avatar
  • 101
0 votes
2 answers
131 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 ...
Hudson Santos's user avatar
1 vote
0 answers
424 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 ...
Bostonian's user avatar
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 ...
John Chase's user avatar
0 votes
2 answers
423 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 ...
nyoto arif's user avatar
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 ...
amphibient's user avatar
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 ...
amyassin's user avatar
  • 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 ...
user2032414's user avatar
1 vote
2 answers
1k 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 ...
user154546's user avatar
2 votes
1 answer
101 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 ...
Lance's user avatar
  • 199
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 ...
owcred601's user avatar
2 votes
1 answer
968 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 ...
S. Doe's user avatar
  • 58
5 votes
1 answer
235 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 ...
James Lester's user avatar
2 votes
1 answer
349 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 ...
ssd_rider's user avatar
11 votes
2 answers
9k 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?
Oreo's user avatar
  • 1,498
5 votes
2 answers
793 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 ...
John Eisbrener's user avatar
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 ...
TheDataGuy's user avatar
  • 1,920
1 vote
2 answers
161 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 ...
user132787's user avatar