如何用程序创建Oracle数据库(32分)

  • 主题发起人 主题发起人 sfjsffjjj
  • 开始时间 开始时间
S

sfjsffjjj

Unregistered / Unconfirmed
GUEST, unregistred user!
你说的数据库实例还是表??
实例用odca,用代码我不懂

表用create table(fieldname datatype,...
 
CREATE USER NewDb
IDENTIFIED BY
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
/
GRANT CONNECT TO NewDb WITH ADMIN OPTION
/
GRANT DBA TO NewDb WITH ADMIN OPTION
/
GRANT RESOURCE TO NewDb WITH ADMIN OPTION
/
GRANT ALTER ANY TABLE TO NewDb WITH ADMIN OPTION
/
GRANT CREATE ANY TABLE TO NewDb WITH ADMIN OPTION
/
GRANT CREATE ANY VIEW TO NewDb WITH ADMIN OPTION
/
GRANT CREATE TABLE TO NewDb WITH ADMIN OPTION
/
GRANT SELECT ANY TABLE TO NewDb WITH ADMIN OPTION
/
GRANT UNLIMITED TABLESPACE TO NewDb WITH ADMIN OPTION
/
 
后退
顶部