Home » RDBMS Server » Server Administration » Assigning datafiles to saparate user in one table space
Assigning datafiles to saparate user in one table space [message #198787] Wed, 18 October 2006 09:15 Go to next message
aorcl
Messages: 2
Registered: July 2006
Junior Member
I have created two datafiles in one tablespace.
i want to assign one datafile to one user and second datafile to second user.

how to make it?


Thanks in advance.
Re: Assigning datafiles to saparate user in one table space [message #198791 is a reply to message #198787] Wed, 18 October 2006 09:42 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Not possible.
You assign only the tablespace(logical) to users(logical).
Not to datafiles (physical).
Re: Assigning datafiles to saparate user in one table space [message #198821 is a reply to message #198787] Wed, 18 October 2006 12:27 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Possible solution .
1. create seperate tbs. and assign one for each user.
Previous Topic: Managing memory in shared mode
Next Topic: Can a DBA see Server Process?
Goto Forum:
  


Current Time: Thu Dec 08 03:52:33 CST 2016

Total time taken to generate the page: 0.15895 seconds