Create tablespace in oracle

General Discussion
5

Thank you Steve for the response. my file is as below

<?xml version="1.0" encoding="UTF-8"?>

<databaseChangeLog

xmlns=“http://www.liquibase.org/xml/ns/dbchangelog”

xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”

xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog

http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd">

select count(*) from v$database where name like ‘%ATG%’

select count(*) from dba_tablespaces  where tablespace_name like  ‘%schema1_DATA’

select count(*) from dba_tablespaces  where tablespace_name like  ‘%schema2_DATA’

create tablespace schema1_data datafile ‘/u01/app/oracle/oradata/"${dbname1}"/schema1_liquibase.dbf’ size 1G ;

CREATE TABLESPACE schema2_DATA DATAFILE ‘/u01/app/oracle/oradata/"${dbname1}"/schema2_liquibase.dbf’ size 1g;

create tablespace schema1_data datafile ‘/u01/app/oracle/oradata/"${dbname2}"/schema1_liquibase1.dbf’ size 1G ;

CREATE TABLESPACE schema2_DATA DATAFILE ‘/u01/app/oracle/oradata/"${dbname2}"/schema2_liquibase.dbf’ size 1g;