Home » SQL & PL/SQL » SQL & PL/SQL » default tablespace of dba user
default tablespace of dba user [message #309398] Thu, 27 March 2008 05:51 Go to next message
shanthis
Messages: 6
Registered: June 2007
Location: Chennai
Junior Member
sir,

I have created the one dba user in oracle9i in system tablespace and i have create some tables in this user. Now i want to change default tablespace (system) to other tablesapce .Please give me the steps to change default tablespace.
Re: default tablespace of dba user [message #309403 is a reply to message #309398] Thu, 27 March 2008 06:09 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ALTER USER

Regards
Michel
Previous Topic: Row prefetch attribute and Stored procedures refcursor
Next Topic: execute immediate with cursor problem
Goto Forum:
  


Current Time: Wed Dec 07 16:47:25 CST 2016

Total time taken to generate the page: 0.10640 seconds