|
⇤ ← Revision 1 as of 2016-11-03 11:10:39
Size: 71
Comment:
|
Size: 292
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 5: | Line 5: |
= create schema(users) = select tablespace_name from user_tablespaces; select USERNAME, DEFAULT_TABLESPACE from DBA_USERS; select USERNAME, DEFAULT_TABLESPACE from DBA_USERS where DEFAULT_TABLESPACE = 'DEV_DB'; |
users
select * from all_users;
create schema(users)
select tablespace_name from user_tablespaces;
select USERNAME, DEFAULT_TABLESPACE from DBA_USERS;
select USERNAME, DEFAULT_TABLESPACE from DBA_USERS where DEFAULT_TABLESPACE = 'DEV_DB';
