Skip to content

Instantly share code, notes, and snippets.

@THUzhangga

THUzhangga/oracle.sql

Created March 28, 2019 06:11
Show Gist options
  • Save THUzhangga/4d042375dc36bffdb7baf2029ceb2038 to your computer and use it in GitHub Desktop.
Save THUzhangga/4d042375dc36bffdb7baf2029ceb2038 to your computer and use it in GitHub Desktop.
Download ZIP
oracle
Raw
oracle.sql
create tablespace chabagou datafile 'E:\oracle\chabagou.dbf' size 500m autoextend on next 500m;
create temporary tablespace chabagoutemp tempfile 'E:\oracle\chabagoutemp.dbf' size 500m autoextend on next 500m;
commit;
create user c##chabagou identified by chabagou default tablespace chabagou temporary tablespace chabagoutemp;
GRANT DBA TO c##chabagou;
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment