Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > 如何更改Oracle中schema或user的名字

如何更改Oracle中schema或user的名字

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-06-07 17:07:02
Original
1765 people have browsed it

开发人员有个需求，要求把某个schema中所有对象移到另一个shema中，后来一想，不就是把schema的名字改了就可以了吗？这样就不用移

开发人员有个需求，要求把某个schema中所有对象移到另一个shema中，后来一想，不就是把schema的名字改了就可以了吗？这样就不用移来移去的，准备用DDL语句直接改的：

  • 发现根本没有这个语句，后来在网上查了一下，才发现，，Oracle本身没有提供这个功能的语句，但有一个数据字典的表：user$，所有的用户都存在这张表中，可以直接update，就尝试着改了一下，发现还挺管用的，实现如下：

    linux

    • Related labels：
    oracle database
    Previous article：MySQL的UDF Next article：MySQL命令解析主要函数调用
    Statement of this Website
    The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
    Latest Articles by Author
    Latest Issues
    Where are the codes for the conn.php and functions.php files?
    From 1970-01-01 08:00:00
    0
    0
    0
    创建数据表错误: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')ENGINE=InnoDB DEFAULT CHARSET=utf8' at line 7
    From 1970-01-01 08:00:00
    0
    0
    0
    Team collaboration - What should I do if someone needs the feature I wrote as a dependency in git flow?
    From 1970-01-01 08:00:00
    0
    0
    0
    Objective-c - Constraints for iOS a warning issue
    From 1970-01-01 08:00:00
    0
    0
    0
    Confusion about using gitlab's fork&pull request mode within the team
    From 1970-01-01 08:00:00
    0
    0
    0
    Related Topics
    More>
    Popular Recommendations
    Popular Tutorials
    More>
    Related Tutorials
    Popular Recommendations
    Latest courses
    Latest Downloads
    More>
    Web Effects
    Website Source Code
    Website Materials
    Front End Template