Create a database solution (Oracle) via SQL script

xiaoxiao2021-03-06  22

/ / Create a database scheme under UNIX, first create a table space, create a user, in the authorized CREATE TABLESPACE table space name DataFile 'newqujiang.dbf' size 5000m; Create a table space Create User Username Identified by password DEFAULT TABLESPACE table space name Temporary TABLESPACE TEMP; Create User Grant DBA To User Name with Admin Option; User Authorized Admin Option; User Authorization Connect

// Import data IMP username / password @ database alias / / export data EXP database name / password @ 别 名

/ / Delete, remove, first delete tablespaces in delete user DROP TABLESPACE table space name include the table space DROP USER username cascade; // Delete the user

转载请注明原文地址:https://www.9cbs.com/read-43591.html

New Post(0)