OraFAQ Forum: Server Administration » Estimation of DataFiles to be added while Importing a new user

Home » RDBMS Server » Server Administration » Estimation of DataFiles to be added while Importing a new user

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Estimation of DataFiles to be added while Importing a new user [message #190721]

Thu, 31 August 2006 23:50

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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

cgk1983
Messages: 28
Registered: December 2005

Junior Member

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

EXACTLY

Report message to a moderator

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

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.

Report message to a moderator

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

joy_division
Messages: 4963
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.

Report message to a moderator

Previous Topic:	Oracle 10g/Fedora Core 4 - Error creating database
Next Topic:	DIM-00008: A valid service name(While Creating New Srvc)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:28:53 CDT 2024