how to create tablesape in oracle

By -
Create tablespace
SQL> create tablesapce tablesape_name
        datafile 'datafilepath'
        size 40m
        autoextend on
        next 32 m
        extend management local;


Create Temporary tablespce 
SQL> create temporary tablesapce tablesape_name
        datafile 'datafilepath'
        size 40m
        autoextend on
        next 32 m

        extend management local;

(temporary tablespce can have only temp files not datafiles )





Looking forward for your suggestions.. please feel free to write to me.. Your help would definitely help to improve our blog. Chetan Yadav

Comments

Post a Comment

Popular posts from this blog

Steps to Handle Loss of Redo Log File

By -
Image
   Steps to Handle Loss of Redo Log File   1.  Identify the Lost Redo Log:         - First, figure out which redo log group and member are missing. You can do this using SQL*Plus or SQL Developer connected to your Oracle database.          SELECT group#, member   FROM v$logfile;                This query will list the redo log groups and their members. Identify the missing one based on its group number and member path.   2.  Check Redo Log Status:    - Next, verify the status of the remaining redo log groups and members to ensure they are intact and available.       SELECT group#, status   FROM v$log;   3.  Restore Lost Redo Log:    - If you have a backup of the lost redo log file, restore it from your backup solution (like RMAN) to its original location.    - If no back...
Read more

Step-by-step guide with commands for configuring Oracle 19c Data Guard Physical Standby

By -
Image
Step 1: Install Oracle 19c software on both primary and standby servers. Download the Oracle Database software for Oracle 19c from the Oracle website. Follow the installation instructions for your operating system to install the Oracle Database software on both the primary and standby servers. Step 2: Create a standby database on the standby server. On the standby server, create an empty Oracle database using the Database Configuration Assistant (DBCA) or manually with SQL scripts. Example SQL script to create a standby database: sql Copy code CREATE DATABASE < database_name > USER SYS IDENTIFIED BY < sys_password > USER SYSTEM IDENTIFIED BY < system_password > LOGFILE GROUP 1 ( '<log_file_directory>/redo01.log' ) SIZE 100 M, GROUP 2 ( '<log_file_directory>/redo02.log' ) SIZE 100 M, GROUP 3 ( '<log_file_directory>/redo03.log' ) SIZE 100 M; Step 3: Enable archivelog mode on the primary database. Connect to the p...
Read more

Transportable Tablespaces

By -
Transportable Tablespaces Transportable tablespaces were introduced in Oracle 8i to allow whole tablespaces to be copied between databases in the time it takes to copy the datafiles. In Oracle 8i one of the restrictions was that the block size of both databases must be the same. In Oracle 9i the introduction of multiple block sizes has removed this restriction. In this article I will run through a simple example of transporting a tablespace between two databases. Setup Source Database Destination Database Cross-Platform Tablespace Conversions Related articles. Oracle Data Pump in Oracle Database 10g (expdp and impdp) Data Pump Enhancements in Oracle Database 11g Release 1 SQL Developer 3.1 Data Pump Wizards (expdp, impdp) Cross-Platform Tablespace Conversion Setup For this example I'm going to create a new tablespace, user and table to work with in the source database. CONN / AS SYSDBA CREATE TABLESPACE test_data DATAFILE '/u01/app/oracle/oradat...
Read more