Better, Faster and Smarter development

Showing posts with label tablespace. Show all posts
Showing posts with label tablespace. Show all posts

Monday, December 16, 2013

Creating tablespace in Oracle and assigning users to schema

CREATE TABLESPACE JournalEntry
datafile 'JournalEntry.dbf'
size 100M;

CREATE USER JE IDENTIFIED BY Journal;

grant all privileges to JE;

alter user <username> default tablespace <tablespace_name>;
at December 16, 2013 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: oracle, tablespace
Older Posts Home
Subscribe to: Comments (Atom)

Search This Blog

About Me

My photo
Kiran Joshi
View my complete profile

Blog Archive

  • ▼  2020 (1)
    • ▼  April (1)
      • Fetching Unique XML Tags based on Values
  • ►  2018 (1)
    • ►  April (1)
  • ►  2016 (5)
    • ►  June (1)
    • ►  April (4)
  • ►  2015 (19)
    • ►  August (2)
    • ►  July (3)
    • ►  June (2)
    • ►  May (1)
    • ►  April (3)
    • ►  March (6)
    • ►  February (1)
    • ►  January (1)
  • ►  2014 (63)
    • ►  December (2)
    • ►  November (7)
    • ►  October (7)
    • ►  September (2)
    • ►  August (3)
    • ►  July (5)
    • ►  May (4)
    • ►  April (4)
    • ►  March (4)
    • ►  February (17)
    • ►  January (8)
  • ►  2013 (33)
    • ►  December (33)
Picture Window theme. Theme images by hdoddema. Powered by Blogger.