oracle19c dbd pdb
时间: 2023-08-29 12:13:31 浏览: 57
Oracle19c introduces a new concept called Pluggable Databases (PDBs) in the Multitenant Architecture. PDBs are self-contained databases within the Oracle Database, allowing multiple databases to share the same database instance. Each PDB can be plugged in or unplugged from the container database (CDB) without affecting other PDBs.
To create a PDB in Oracle 19c, you can use the Database Configuration Assistant (DBCA) or run SQL commands. Here is an example of creating a PDB using SQL:
1. Connect to the CDB:
```
sqlplus sys/password@<CDB_SID> as sysdba
```
2. Create a new PDB:
```
CREATE PLUGGABLE DATABASE <PDB_NAME>
ADMIN USER <PDB_ADMIN_USER> IDENTIFIED BY <PDB_ADMIN_PASSWORD>
FILE_NAME_CONVERT=('<CDB_DATAFILE_DIR>','<PDB_DATAFILE_DIR>');
```
Replace <PDB_NAME> with the name of your PDB, <PDB_ADMIN_USER> and <PDB_ADMIN_PASSWORD> with the administrator username and password for the PDB, and <CDB_DATAFILE_DIR> and <PDB_DATAFILE_DIR> with the directory paths for data files in the CDB and PDB, respectively.
3. Open the new PDB:
```
ALTER PLUGGABLE DATABASE <PDB_NAME> OPEN;
```
You can now connect to the PDB using a separate connection string and perform operations specific to that PDB. Keep in mind that managing PDBs requires knowledge of Oracle Multitenant Architecture. I hope this helps! Let me know if you have any further questions.