blocks|key|1904939|text|SQL>+select+Username+from+dba_users
++2++;

USERNAME
------------------------------
SYS
SYSTEM
ANONYMOUS
APEX_PUBLIC_USER
FLOWS_FILES
APEX_040000
OUTLN
DIP
ORACLE_OCM
XS$NULL
MDSYS

USERNAME
------------------------------
CTXSYS
DBSNMP
XDB
APPQOSSYS
HR

16+rows+selected.

SQL>+create+user+testdb+identified+by+password;

User+created.

SQL>+select+username+from+dba_users;

USERNAME
------------------------------
TESTDB
SYS
SYSTEM
ANONYMOUS
APEX_PUBLIC_USER
FLOWS_FILES
APEX_040000
OUTLN
DIP
ORACLE_OCM
XS$NULL

USERNAME
------------------------------
MDSYS
CTXSYS
DBSNMP
XDB
APPQOSSYS
HR

17+rows+selected.

SQL>+grant+create+session+to+testdb;

Grant+succeeded.

SQL>+create+tablespace+testdb_tablespace
++2++datafile+'testdb_tabspace.dat'
++3++size+10M+autoextend+on;

Tablespace+created.

SQL>+create+temporary+tablespace+testdb_tablespace_temp
++2++tempfile+'testdb_tabspace_temp.dat'
++3++size+5M+autoextend+on;

Tablespace+created.

SQL>+drop+user+testdb;

User+dropped.

SQL>+create+user+testdb
++2++identified+by+password
++3++default+tablespace+testdb_tablespace
++4++temporary+tablespace+testdb_tablespace_temp;

User+created.

SQL>+grant+create+session+to+testdb;

Grant+succeeded.

SQL>+grant+create+table+to+testdb;

Grant+succeeded.

SQL>+grant+unlimited+tablespace+to+testdb;

Grant+succeeded.

SQL>|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1904940|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>SQL&gt; select Username from dba_users
 2 ;

USERNAME
------------------------------
SYS
SYSTEM
ANONYMOUS
APEX_PUBLIC_USER
FLOWS_FILES
APEX_040000
OUTLN
DIP
ORACLE_OCM
XS$NULL
MDSYS

USERNAME
------------------------------
CTXSYS
DBSNMP
XDB
APPQOSSYS
HR

16 rows selected.

SQL&gt; create user testdb identified by password;

User created.

SQL&gt; select username from dba_users;

USERNAME
------------------------------
TESTDB
SYS
SYSTEM
ANONYMOUS
APEX_PUBLIC_USER
FLOWS_FILES
APEX_040000
OUTLN
DIP
ORACLE_OCM
XS$NULL

USERNAME
------------------------------
MDSYS
CTXSYS
DBSNMP
XDB
APPQOSSYS
HR

17 rows selected.

SQL&gt; grant create session to testdb;

Grant succeeded.

SQL&gt; create tablespace testdb_tablespace
 2 datafile 'testdb_tabspace.dat'
 3 size 10M autoextend on;

Tablespace created.

SQL&gt; create temporary tablespace testdb_tablespace_temp
 2 tempfile 'testdb_tabspace_temp.dat'
 3 size 5M autoextend on;

Tablespace created.

SQL&gt; drop user testdb;

User dropped.

SQL&gt; create user testdb
 2 identified by password
 3 default tablespace testdb_tablespace
 4 temporary tablespace testdb_tablespace_temp;

User created.

SQL&gt; grant create session to testdb;

Grant succeeded.

SQL&gt; grant create table to testdb;

Grant succeeded.

SQL&gt; grant unlimited tablespace to testdb;

Grant succeeded.

SQL&gt;
</code></pre>

blocks|key|1691570|text|这是一个有效的示例：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1691571|CREATE+USER+auto_exchange+IDENTIFIED+BY+123456;
GRANT+RESOURCE+TO+auto_exchange;
GRANT+CONNECT+TO+auto_exchange;
GRANT+CREATE+VIEW+TO+auto_exchange;
GRANT+CREATE+SESSION+TO+auto_exchange;
GRANT+UNLIMITED+TABLESPACE+TO+auto_exchange;|code-block|syntax|javascript|1691572|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

It's a working example:

<pre><code>CREATE USER auto_exchange IDENTIFIED BY 123456;
GRANT RESOURCE TO auto_exchange;
GRANT CONNECT TO auto_exchange;
GRANT CREATE VIEW TO auto_exchange;
GRANT CREATE SESSION TO auto_exchange;
GRANT UNLIMITED TABLESPACE TO auto_exchange;
</code></pre>

blocks|key|1691636|text|在oracle+Sql+developer中，在sql+worksheet中执行以下内容：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1691637|create+user+lctest+identified+by+lctest;
grant+dba+to+lctest;|code-block|syntax|javascript|1691638|然后右键单击"Oracle+connection“->新连接，然后将从连接名到用户名密码的所有内容都设置为lctest。测试连接应通过。然后，在连接之后，您将看到架构。|1691639|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

From oracle Sql developer, execute the below in sql worksheet:

<pre><code>create user lctest identified by lctest;
grant dba to lctest;
</code></pre>

then right click on "Oracle connection" -> new connection, then make everything lctest from connection name to user name password. Test connection shall pass. Then after connected you will see the schema.

I have applied for an internship in a company and as a question they have asked me to create a schema for their company with certain requirements and mail them the DDL file. I have installed Oracle database 11g Express edition, but how do I create a new schema in Oracle database 11g? I have searched in the net for a solution but I could not understand what to do. And after creating a schema, which file should I mail them?

How to create a new schema/new user in Oracle Database 11g?

Oracle数据库

数据库

我申请了一家公司的实习，作为一个问题，他们要求我为他们的公司创建一个具有特定需求的模式，并将DDL文件发送给他们。我已经安装了Oracle数据库11g Express版，但是如何在Oracle数据库11g中创建新的模式？我已经在网上寻找了解决方案，但我不知道该怎么办。创建模式后，我应该将哪个文件发送给他们？

问如何在Oracle Database 11g中创建新架构/新用户？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Oracle Database 11g中创建新架构/新用户？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Oracle Database 11g中创建新架构/新用户？
EN