Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 898
  • Last Modified:

datafile

I need to increase the size of a datafile but it is already at its maxsize. How do I increase the maxsize of a datafile so I can resize it.
0
msimons4
Asked:
msimons4
6 Solutions
 
sdstuberCommented:
ALTER DATABASE
  DATAFILE '/your/data/file/goes_here.dbf'
 AUTOEXTEND ON
   MAXSIZE 1234M;  -- adjust size to whatever you need
0
 
sdstuberCommented:
you can specify the maxsize in bytes  (no units)

or K, M, G, T, P, E  


kilobytes
megabytes
gigabytes
terabytes
petabytes
exabytes
0
 
sventhanCommented:
<  but it is already at its maxsize

What is your max size? Is autoextend on?

What is the block size of the DB?

0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
sdstuberCommented:
also note, you can manually resize a datafile beyond it's maxsize.

the maxsize only applies to autoextend.

So, if your datafile is 1G max, you can resize it to 2G, but it won't autoextend because it's already beyond the max size
0
 
msimons4Author Commented:
Is it better to increase the maxsize of the datafile or just increase the size of the datafile
0
 
sdstuberCommented:
neither is "better" than the other, but I would probably increase the maxsize and then let the datafile autoextend as needed


you could resize it also if you know you'll need 100Mb  now and "maybe" 100Mb later, then set the maxsize 200Mb bigger and resize 100Mb now
0
 
slightwv (䄆 Netminder) Commented:
Just to add that extending datafiles is expensive.  If you let it autoextend you have no control when it happens and can take place during the busy times.

You should also set the NEXT size on autoextend to a decent size you it doesn't extend all the time.

0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now