Database Administration (MOSC)

MOSC Banner

How big datafile is good for 400G's data?

edited Apr 1, 2014 12:00PM in Database Administration (MOSC) 6 commentsAnswered

I only has a PC server.  This PC server is running on a hard disk. This disk has 1000G space.

I installed Redhat EL6.2 x86_64 at this PC server. I also installed a Oracle11g R2 at this Redhat server.

Now I need to set up a schema. This schema should contain about 400G's data.  (A third party system will import 400G's data to this schema)

So I set up a tablespace for this schema.

But how to make datafile to this tablespace?

If I make a datafile 1G, then I have to make 400 data files to this tablespace. I don't think it's good to have so many data file.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center