| datafile [message #309641] |
Fri, 28 March 2008 04:59  |
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 #309650 is a reply to message #309642] |
Fri, 28 March 2008 05:32  |
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 |
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 |
Frank Naude
Messages: 4587
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 #309658 is a reply to message #309650] |
Fri, 28 March 2008 05:47 |
 |
Littlefoot
Messages: 21823
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 |
Frank Naude
Messages: 4587
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 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
