Tag: Tablespace

Oracle – Create tablespace and User / Schema

Oracle, Oracle-Tips and Tricks, Varinder Sandhu

Creating a tablespace and user is a very common task after creating an oracle database. Before going further must read the post Schema vs. User In this post we will see how to create tablespace and user with example Tablespace Each tablespace in an Oracle database consists of one or more files called data files. A permanent tablespace contains persistent schema objects. Objects in permanent tablespaces are stored in data files. Script 1: Create Tablespace CREATE TABLESPACE "test01" LOGGING DATAFILE

» Read more
, , , ,

Oracle – DBA Basics

Oracle, Oracle-Tips and Tricks, Varinder Sandhu

First I would like to share some background of this post. As I have SQL Server background (you can see in my profile here) and when I started learning Oracle. I have so many basic questions regarding oracle environment. Even I was little lit bit confused about few things. But when I got the answer of my question then I thought I should write here on my blog. Oracle and SQL server are very different products.  There is no comparison

» Read more
, , , , ,