PL/SQL How to create a new database on a cloud server

Oracle new database is different from SQL Server and cannot be created directly, the process of creating a new database is as follows:

1. Build a table space first

2. Create a new user and manage the table space

3. Give new users permission to manage table spaces

Create a new database code on the local server as follows:

--First build table space create tablespace mianyang_tbs datafile ' E:\oracle\mianyang.dbf ' size 100m;--create user Mianyang identified By Mianyang The default tablespace mianyang_tbs;--grants the user permission to the grant Connect,resource to the Mianyang;grant dba to Mianyang;

The storage location of tablespace data is E:\oracle\mianyang.dbf;

To create a new database on a cloud server, simply replace the tablespace data storage location with the corresponding IP address, as follows:

--First build table space create tablespace mianyang_tbs datafile ' 149.178.10.104:\mianyang.dbf ' size 100m;--create user Mianyang Iden Tified by Mianyang default tablespace mianyang_tbs;--gives the user permissions to the grant Connect,resource to the Mianyang;grant dba to Mianyang;

PL/SQL How to create a new database on a cloud server