Can we rename Oracle username & tablespace name in 11g R2
- We have Oracle tablespace name "TULIP"
- We have Oracle username "TULIP"
Default tablespace for use TULIP is TULIP.
- Now can we rename tablespace TULIP to TULIP_NEW ?
- Now can we rename username TULIP to TULIP_NEW ?
Can this be done online when the database is running ?
If NOT please give me the steps involved.
Thanks
Bristol