Link to home
Start Free TrialLog in
Avatar of nobleit
nobleit

asked on

change tablespace

I created a user us1 identfied by us1
default tablespace rman;

user created

but I also wanted to add 'temporary tablespce temp'
while creating the user. May I update it?
Avatar of cheers4beers
cheers4beers
Flag of United States of America image

Use the following:

Alter user us1 default temporary tablspace TEMP;
ASKER CERTIFIED SOLUTION
Avatar of cheers4beers
cheers4beers
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial