Home » RDBMS Server » Server Administration » 2GB datafile
2GB datafile [message #224458] Wed, 14 March 2007 06:34 Go to next message
preet_kumar
Messages: 204
Registered: March 2007
Senior Member
My current database is running on 32bit OS and datafiles are of size 2GB.
Is it possible for me to combine the datafiles and create a single 20GB datafile when i migrate to 64bit OS.

Report message to a moderator

Re: 2GB datafile [message #224460 is a reply to message #224458] Wed, 14 March 2007 06:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>when i migrate to 64bit OS
In 64 bit OS, yes.
You cannot just 'combine' the datafiles.
Create a tablespace with one datafile of 20gb.

Report message to a moderator

Re: 2GB datafile [message #224468 is a reply to message #224458] Wed, 14 March 2007 07:00 Go to previous messageGo to next message
preet_kumar
Messages: 204
Registered: March 2007
Senior Member
Do you mean using bigfile tablespace i create a big single datafile.But how can i get the data from old datafiles which consist of about 10(2GB files).

Report message to a moderator

Re: 2GB datafile [message #224472 is a reply to message #224468] Wed, 14 March 2007 07:10 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
bigfile tablespaces are typically meant for terabyte datafiles.
20gb is minuscule Smile
>>But how can i get the data from old datafiles which consist of about 10(2GB files)
Upto you.
You can export/import the schema.
You can just move the objects to another tablespace (alter table move)..
You can use online redefinition using dbms_redefinition.
All you need is to create a new tablespace with one 20gb datafile and choose your method.
On other hand, i would consider backup/recovery implications of backing a sinlge 20gb file Smile
Again, it is upto you and your need.

Report message to a moderator

Previous Topic: RE: Storage Problem
Next Topic: Problem with ASM Disk on Linux
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 03:35:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.