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.

Report message to a moderator

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: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Not possible.
You assign only the tablespace(logical) to users(logical).
Not to datafiles (physical).

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Managing memory in shared mode
Next Topic: Can a DBA see Server Process?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 06:35:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.