Differences between revisions 1 and 2
Revision 1 as of 2016-11-03 11:10:39
Size: 71
Editor: localhost
Comment:
Revision 2 as of 2016-11-03 11:26:04
Size: 292
Editor: localhost
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';

désert/Oracle/create_new_schema (last edited 2017-04-27 08:33:53 by merlyn)