Advertisement
Guest User

create datatabse

a guest
May 3rd, 2016
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. CREATE DATABASE SBD
  2. USER sys identified by sbd
  3. USER system identified by sbd
  4. MAXDATAFILES 50
  5. MAXLOGFILES 5
  6. MAXLOGMEMBERS 4
  7. CHARACTER SET WE8MSWIN1252
  8. NOARCHIVELOG
  9. MAXINSTANCES 1
  10. DATAFILE 'C:\oracle11g\oradata\sbd\DATA\SYSTEM01.DBF'
  11. SIZE 250M REUSE AUTOEXTEND ON NEXT 20M
  12. MAXSIZE UNLIMITED
  13. EXTENT MANAGEMENT LOCAL
  14. SYSAUX DATAFILE 'C:\oracle11g\oradata\sbd\data\sysaux01.dbf'
  15. size 80m reuse autoextend on next 20m
  16. maxsize unlimited
  17. default temporary tablespace temp
  18. tempfile 'C:\oracle11g\oradata\sbd\temp\temp01.dbf'
  19. size 15m reuse autoextend on next 5m
  20. maxsize 30m
  21. undo tablespace undotbs1
  22. datafile 'c:\oracle11g\oradata\sbd\undo\undotbs1.dbf'
  23. size 10m
  24. logfile
  25. group 1 ('C:\oracle11g\oradata\sbd\red01\red01.log') size 150m,
  26. group 2 ('C:\oracle11g\oradata\sbd\red02\red02.log') size 150m;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement