'defaulted/pointed' to the right tablespace [message #464592] |
Thu, 08 July 2010 08:15 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
reym21
Messages: 241 Registered: February 2010 Location: Philippines
|
Senior Member |
![vyer.atarom@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
Sir/Ma'am,
As I queried our newly created db and checked if the tables I created were supposed to be on the default tablespace (LEDGER)using this SQL command:
SQL> select owner, table_name, tablespace_name from dba_tables
2 where owner = 'ELEDGER01';
OWNER TABLE_NAME TABLESPACE_NAME
-------------------- --------------------- ---------------
ELEDGER01 USER_INFO USERS
ELEDGER01 CERTIFICATES USERS
I need to know how would I point those 2 tables for it's supposed or right tablespace (from USERS to LEDGER)..
Thanks again.
|
|
|
|
|
|
|
|
Re: 'defaulted/pointed' to the right tablespace [message #464617 is a reply to message #464615] |
Thu, 08 July 2010 09:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:I connected as sysdba
Do NOT do that.
- Never ever use SYS (or SYSDBA) but for maintenance purpose (startup, shutdown, backup, recover)
- SYS/SYSDBA is special
- SYS/SYSDBA is Oracle proprietary (try to open a SR/TAR starting with "i did that with SYS/SYSDBA" and you'll see the immediate answer)
- SYS/SYSDBA does not act like any other user
- When you use SYS/SYSDBA Oracle deactivates some code path and activates others
- Whatever you do with SYS/SYSDBA will neither validate nor invalidate the same thing with any other user.
NEVER EVER use SYS/SYSDBA for anything that can be done by another user.
Use SYS/SYSDBA ONLY for something that can't be done by someone else.
Regards
Michel
|
|
|