We all know that Oracle's relational database is the world's first database supporting SQL languages. It has many purposes, so the following articles mainly introduce the actual operations of Oracle to modify the table owner. This article mainly uses code to introduce its actual operations.
- 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 the owner of the Oracle modification table. I hope you will have some gains.