thedbRAVIew

 Hi everyone, Suppose you receive a request from a client to create a new user/schema in the Oracle Database. Here are the steps you need to follow after connecting to Database as sys user: STEP 1: Determine the storage type of the database (file system, ASM, etc.). STEP 2: Identify the location of the datafiles. STEP 3: Create a tablespace and allocate an appropriate size for its datafile. STEP 4: Create the user and associate the newly created tablespace with the user. STEP 5: Grant necessary permissions to the user. STEP 6: Verify connectivity in database. By following these steps, you will be able to successfully create a new user in the Oracle Database. STEP 1: Determine the storage type of the database (file system, ASM, etc.). STEP 2: Identify the location of the datafiles. set linesize 189 pages 2000 col tabelspace_name for a30 col file_name for a50 col bytes for a30 col bytes for 999999 select tablespace_name, file_name, bytes/1024/1024 as TOTAL_SIZE_IN_MB from dba_data_fi...

 Hi everyone, Suppose you receive a request from a client to create a new user/schema in the Oracle Database. Here are the steps you need to follow after connecting to Database as sys user: STEP 1: Determine the storage type of the database (file system, ASM, etc.). STEP 2: Identify the location of the datafiles. STEP 3: Create a tablespace and allocate an appropriate size for its datafile. STEP 4: Create the user and associate the newly created tablespace with the user. STEP 5: Grant necessary permissions to the user. STEP 6: Verify connectivity in database. By following these steps, you will be able to successfully create a new user in the Oracle Database. STEP 1: Determine the storage type of the database (file system, ASM, etc.). STEP 2: Identify the location of the datafiles. set linesize 189 pages 2000 col tabelspace_name for a30 col file_name for a50 col bytes for a30 col bytes for 999999 select tablespace_name, file_name, bytes/1024/1024 as TOTAL_SIZE_IN_MB from dba_data_fi...

Hello everyone,   Welcome to my blog! I'm Ravi Kiran, an Oracle Database Administrator. I have created this blog to share my knowledge of Oracle Database with fellow DBAs. In this blog, you will find valuable information about Oracle DB, Oracle Data Guard, Oracle RAC, and more. I encourage you to leave your comments and thoughts, and feel free to point out anything I may have missed. Let's come together and create an amazing DB community where we can support and learn from each other.   Thank you for visiting, and I look forward to our journey together.   Best regards, Ravi Kiran