我申请了一家公司的实习,作为一个问题,他们要求我为他们的公司创建一个具有特定需求的模式,并将DDL文件发送给他们。我已经安装了Oracle数据库11g Express版,但是如何在Oracle数据库11g中创建新的模式?我已经在网上寻找了解决方案,但我不知道该怎么办。创建模式后,我应该将哪个文件发送给他们?
发布于 2017-02-17 16:23:26
这是一个有效的示例:
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;
发布于 2015-12-08 04:05:03
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>
发布于 2019-08-23 04:54:14
在oracle Sql developer中,在sql worksheet中执行以下内容:
create user lctest identified by lctest;
grant dba to lctest;
然后右键单击"Oracle connection“->新连接,然后将从连接名到用户名密码的所有内容都设置为lctest。测试连接应通过。然后,在连接之后,您将看到架构。
https://stackoverflow.com/questions/18403125
复制相似问题