Home » RDBMS Server » Server Administration » Estimation of DataFiles to be added while Importing a new user
Estimation of DataFiles to be added while Importing a new user [message #190721] Thu, 31 August 2006 23:50 Go to next message
cgk1983
Messages: 28
Registered: December 2005
Junior Member

I want to import a user from a dump file But i dont know how many DataFiles i have to create for this particular user in the destination Oracle Database server.

Because many of the times i will get the errror "Unable to create Extent for particular Tablespaces"

What i want is based on a particular user which i want to export i need to know how many datafiles are needed to be created at the DESTINATION SERVER where i will import the user
Re: Estimation of DataFiles to be added while Importing a new user [message #190763 is a reply to message #190721] Fri, 01 September 2006 02:52 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Hi

You could look at the number of bytes the user uses on the original database.

Or You can just trial and error.

1 Import.
2 If fail,
3 add file(s).
4 Drop user
5 goto 1
6 End if


Br
Kim
Re: Estimation of DataFiles to be added while Importing a new user [message #190770 is a reply to message #190763] Fri, 01 September 2006 03:09 Go to previous messageGo to next message
cgk1983
Messages: 28
Registered: December 2005
Junior Member
But it is time waste dropping user so many times and again Creating

Is there no other alternative
Re: Estimation of DataFiles to be added while Importing a new user [message #190773 is a reply to message #190770] Fri, 01 September 2006 03:17 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Hi

Another approach is to add many files, which all can autoextend a lot.
This way, they will increase to the size needed.

Br
Kim
Re: Estimation of DataFiles to be added while Importing a new user [message #190777 is a reply to message #190773] Fri, 01 September 2006 03:26 Go to previous messageGo to next message
cgk1983
Messages: 28
Registered: December 2005
Junior Member
I want exactly and very accurately how many Datafiles needed for that DUMP File

EXACTLY
Re: Estimation of DataFiles to be added while Importing a new user [message #190778 is a reply to message #190777] Fri, 01 September 2006 03:27 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
cgk1983 wrote on Fri, 01 September 2006 10:26

I want exactly and very accurately how many Datafiles needed for that DUMP File

EXACTLY


*G* ok. 17.

Re: Estimation of DataFiles to be added while Importing a new user [message #190838 is a reply to message #190778] Fri, 01 September 2006 08:48 Go to previous message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
I thought headaches like this went out with v7 of the database. Just make auto extend datafiles. If you want it so "exact" then start them out as 1 megabyte with 1 megabyte increases if you wish. Set your LMT tablespaces to system managed and ler 'er rip.
Previous Topic: Oracle 10g/Fedora Core 4 - Error creating database
Next Topic: DIM-00008: A valid service name(While Creating New Srvc)
Goto Forum:
  


Current Time: Wed Dec 07 22:46:02 CST 2016

Total time taken to generate the page: 0.11808 seconds