I am new to SQL, using SQL Developer 2014.
I created a SQL database by importing tables from an existing Access DB. Now I'm poking around to see what I can learn. I clicked on the 'Files' group in the Database properties viewer.
In the 'Database' group there is and 'Size' entry with a value of 39853.50 MB
Directly underneath that entry is 'Space Available' with a value of .078MB.
Does that mean I am almost out of space? One reason for going to SQL from our old Access DB was to be able to store much more data.
I will eventually need to store a lot more data in this SQL DB, probably up to 10 times what I have now.
Where is the size of the DB, or space allocated to the DB set in SQL? In other DB's I've used a primary space was allocated with rollover size increments if the data outgrew the original definition.
In general how is the disk space allocation handled and managed in SQL?