Common Oracle database users

As a super-large-scale database, Oracle stores more data than general databases. The following describes the architecture of Oracle databases, the following is a detailed introduction of the article. I hope you will gain some benefits after browsing the following content.

Oracle databases include Oracle database servers and clients.

Oracle Database Server:

Oracle Server is an object-1 relational database management system. It provides open, comprehensive, and integrated information management methods. Each Server is composed of an Oracle DB and an Oracle Server instance. It has Site Autonomy and provides transparent data storage mechanisms to achieve data storage transparency. Each Oracle database corresponds to a unique instance name SID. After the Oracle database server is started,

Generally, there are at least the following users:

Internal, which is not a real user name, but an alias of Sys users with SYSDBA priority. It is used by DBA users to complete database management tasks, including starting and disabling databases; Sys, it is a DBA user name with the maximum database operation permissions; System, it is also a DBA user name, the permissions are second only to Sys users.

Client:

The database user operation end is composed of applications, tools, and SQL * NET. When a user operates a database, the database must be connected to a server called a Local database ). In the network environment, databases on other servers are called Remote databases ). To access data in a remote database, you must establish a database chain.

The architecture of the Oracle database includes the physical and logical storage structures. Because they are separated, the access to the logical storage structure is not affected when you manage the physical storage structure of data.

Oracle Modify Table owner

 
 

  
  
create user test identified by test  
  
  
grant resource,connect to test;  
  
  
create table t1 (id number,name varchar2(20));  
  
  
insert into t1 values (1,'xx');  
  
  
commit;  
  
  
grant all on t1 to test1;  
 
 

Such operations seem to be only allowed in the same database.

 
 

  
  
create user test1 identified by test1  
  
  
grant resource,connect to test1;  
  
  
conn test1/test1  
  
  
create table temp(id number,name varchar2(20)) 
partition by range(id)  
  
  
(partition part0 values less than (-1),  
  
  
partition part1 values less than (maxvalue));  
  
  
create table t1(id number,name varchar2(20));  
  
  
alter table temp exchange partition part1 with
 table test.t1  
  
  
including indexes without validation;  
  
  
alter table temp exchange partition part1 with 
table t1 including indexes without validation;  
 
 

The above content is an introduction to some of the content of the owner of the Oracle database and the Oracle modification table.