/ / 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