Home » Developer & Programmer » Application Express & MOD_PLSQL » datafile (DB XE)
datafile [message #309641] Fri, 28 March 2008 04:59 Go to next message
Joneto
Messages: 13
Registered: February 2008
Location: Portugal
Junior Member
Hi,
I used one tablespace for all users(4).
how do i do create one datafile for user only?

Regards

Joneto
Re: datafile [message #309642 is a reply to message #309641] Fri, 28 March 2008 05:09 Go to previous messageGo to next message
Frank Naude
Messages: 4420
Registered: April 1998
Senior Member
I would prefer having them all in a single tablespace. Why do you want them in different tablespaces?
Re: datafile [message #309650 is a reply to message #309642] Fri, 28 March 2008 05:32 Go to previous messageGo to next message
Joneto
Messages: 13
Registered: February 2008
Location: Portugal
Junior Member
Hi,

Why not?
DB XE -> max. is 4GB...
My idea is one user -> one datafile.
If i don't more used user.
I delete drop user and cascada and delete datafile.

It's correct?

Regards

Joneto
Re: datafile [message #309652 is a reply to message #309642] Fri, 28 March 2008 05:33 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi

may be licence free 4 GB database limitation. However, will the multi user can solve this limitation.. I doubt anyway let me
also wait for some feed back

yours
dr.s.raghunathan
Re: datafile [message #309654 is a reply to message #309652] Fri, 28 March 2008 05:38 Go to previous messageGo to next message
Frank Naude
Messages: 4420
Registered: April 1998
Senior Member
The limit is 4GB for the entire database, including all tablespaces and all data files. So, you are out of luck. Looks like you will have to buy an Oracle license.
Re: datafile [message #309655 is a reply to message #309654] Fri, 28 March 2008 05:42 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi

how can i measure the extent of usage of my database

yours
dr.s.raghunathan
Re: datafile [message #309658 is a reply to message #309650] Fri, 28 March 2008 05:47 Go to previous messageGo to next message
Littlefoot
Messages: 19525
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Reading your question, Joneto, I wonder what is your background? Is Oracle your first database? I'd say not. Did you read the Concepts book (can be found in documentation).

Joneto
My idea is one user -> one datafile.
If i don't more used user.
I delete drop user and cascada and delete datafile.

It's correct?
As far as I can tell, no - it is not correct. Frank already asked WHY would you want to do that? In Oracle, create user (which, along with its objects as tables, indexes, views, procedures etc. makes a schema). Let it exist as long as you need. Once you don't need it, drop user and that's all. Why would you bother with tablespaces, datafiles and such things? Unless you have a very, very good reason, I believe you should discard this idea completely (especially if your choice is XE (and it is)).
Re: datafile [message #309674 is a reply to message #309658] Fri, 28 March 2008 07:25 Go to previous messageGo to next message
Frank Naude
Messages: 4420
Registered: April 1998
Senior Member
Quote:
how can i measure the extent of usage of my database


SQL> SELECT SUM(bytes)/1024/1024 "Meg" FROM dba_segments;
Re: datafile [message #309701 is a reply to message #309658] Fri, 28 March 2008 09:07 Go to previous message
Joneto
Messages: 13
Registered: February 2008
Location: Portugal
Junior Member
well...
my problem...
Result my view tablespace: Percent space: 20%
if i create one user and import file *.dmp.
After, result my view tablespace: Percent space: 33%
I drop user and cascade.
After, result my view tablespace: Percent space: 33%
why percent space not reduze?!

Regards

Joneto

PS: How i can reduze space?

[Updated on: Fri, 28 March 2008 09:07]

Report message to a moderator

Previous Topic: pool data in different schema's table
Next Topic: Checksum
Goto Forum:
  


Current Time: Fri Aug 29 21:31:34 CDT 2014

Total time taken to generate the page: 0.10622 seconds