Success is The Progressive Realization Of A Worthy Ideal

Wednesday, February 27, 2013

create new user in oracle with separate datafiles and tablespace




create tablespace myatpl datafile 'D:\app\Administrator\oradata\vxmldb\myatpl01.dbf '
size 200m autoextend on next 100m maxsize unlimited;

create user myatpl identified by myatpl123 default tablespace myatpl;

grant resource,connect to myatpl

ALTER USER myatpl QUOTA unlimited ON myatpl;
Posted by Unknown at 7:56 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Unknown
View my complete profile

Blog Archive

  • ►  2014 (1)
    • ►  January (1)
  • ▼  2013 (62)
    • ►  October (1)
    • ►  July (1)
    • ►  April (14)
    • ►  March (33)
    • ▼  February (13)
      • SET MYSQL PASSWORD
      • kill oracle sessions
      • Increase the session in Oracle
      • AWR report
      • Restore a single table from a whole db backup mysql
      • rename database in sqlserver if database is runnin...
      • set mysql password for root user if forget
      • create data base link in oracle
      • Remote server backup of sqlserver
      • JOINS ORACLE
      • create new user in oracle with separate datafiles ...
      • Data warehouse
      • mysql clustering basics
  • ►  2012 (2)
    • ►  July (2)
  • ►  2010 (1)
    • ►  May (1)
  • ►  2009 (1)
    • ►  December (1)
  • ►  2008 (26)
    • ►  July (14)
    • ►  June (12)
Ethereal theme. Powered by Blogger.