What code does Oracle use to modify the table owner?

Source: Internet
Author: User

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.

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

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

 
 
  1. create user test1 identified by test1  
  2. grant resource,connect to test1;  
  3. conn test1/test1  
  4. create table temp(id number,name varchar2(20)) partition by range(id)  
  5. (partition part0 values less than (-1),  
  6. partition part1 values less than (maxvalue));  
  7. create table t1(id number,name varchar2(20));  
  8. alter table temp exchange partition part1 with table test.t1  
  9. including indexes without validation;  
  10. 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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.