Home » RDBMS Server » Server Utilities » Import file Size
Import file Size [message #227458] Wed, 28 March 2007 05:23 Go to next message
preet_kumar
Messages: 195
Registered: March 2007
Senior Member
I did an export from 8.1.7(on solaris) which had a tablespace consisting of 5x2GB datafiles but now when i do an import to 10g(Linux) it creates the tablespace with single datafile the size of which is 9GB.
Will i have any problem in the future with this,also i didnt specified big file tablespace.

Thanks in advance
Re: Import file Size [message #227488 is a reply to message #227458] Wed, 28 March 2007 06:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> it creates the tablespace with single datafile the size of which is 9GB.
Imp will create the tablespace only if there is the same files structure available and if so , the same datafiles /tablespaces will be created.
In your case, it seems you have precreate the tablespace.
>>Will i have any problem in the future with this,also i didnt specified big file tablespace.
You have to tell. Look into the logfile. See if all objects areimported.
BIGFILE tablespaces are meant for terabyte datafiles.
9gb is minuscule. A regular tablespace will be just fine.
Re: Import file Size [message #227507 is a reply to message #227488] Wed, 28 March 2007 07:35 Go to previous messageGo to next message
preet_kumar
Messages: 195
Registered: March 2007
Senior Member
I need to create the tablespace with the datafiles so that it dosent get larger,the problem with large single datafiles is its difficult to copy to remote systems.
In the logfile it shows all objects are imported but gets everything in one huge datafile which id difficult to manage so i think the best is create the tablespace and the datafiles and then do the import.


>> it creates the tablespace with single datafile the size of which is 9GB.
Imp will create the tablespace only if there is the same files structure available and if so , the same datafiles /tablespaces will be created.
In your case, it seems you have precreate the tablespace.
>>Will i have any problem in the future with this,also i didnt specified big file tablespace.
You have to tell. Look into the logfile. See if all objects areimported.
BIGFILE tablespaces are meant for terabyte datafiles.
9gb is minuscule. A regular tablespace will be just fine.
Re: Import file Size [message #227537 is a reply to message #227507] Wed, 28 March 2007 09:19 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>which id difficult to manage
As i said before, 9gb is NOTHING!.
What difficulty are you expecting to arise?
>> best is create the tablespace and the datafiles and then do the import
Upto you.
You create tablespace with multiple small datafiles and do the import.
>>with large single datafiles is its difficult to copy to remote systems.
Not exactly correct.
One large file is always better than multiple small files (save yourself from network roundtrips).
Previous Topic: can we use '<' with WHEN in sqlldr??
Next Topic: SQL Load..char string problem with 10g
Goto Forum:
  


Current Time: Mon Dec 05 07:14:18 CST 2016

Total time taken to generate the page: 0.04790 seconds