Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

create a 2nd pluggable database on the media drive

Chincheng37Apr 18 2020

Hi there,

I have the oracle 12c r2 installed, and would like to create another pluggable database on another drive, i.e. an usb drive. I tried the following ways -

1). Creating a PDB by Using the Seed;

code:

create pluggable database PDBCDB2 admin user testuser identified by testuserpwd

DEFAULT TABLESPACE USERS
    DATAFILE '/disk1/u01/app/oracle/oradata/cdb1/pdbcdb2/users01.dbf' SIZE 250M AUTOEXTEND ON

FILE_NAME_CONVERT=(‘/disk1/u01/app/oracle/oradata/cdb1/pdbseed’,’/disk2/u01/app/oracle/oradata/cdb1/pdbcdb2’);

2). Cloning a PDB From an Existing PDB;

code:

CREATE PLUGGABLE DATABASE PDBCDB2 FROM PDBCDB1

FILE_NAME_CONVERT=( ‘/disk1/u01/app/oracle/oradata/cdb1/pdbcdb1/’, ‘/disk2/u01/app/oracle/oradata/cdb1/pdbcdb2/’);

Both ways it ends up with the same sort of error message:

ORA-65005: missing or invalid file name pattern for file -

/disk1/u01/app/oracle/oradata/CDB1/datafile/o1_mf_system_h4mfhqq2_.dbf

Can anyone please point me to the right direction to accomplish this job?

Many thanks in advance.

Comments

Jerry Casey
Answer

Hi bej,
I work in 11.1.1.9.5, but there is a conditional format option under the style dialog for graph properties.
pastedImage_0.png
You'll have to set the format for however many categories you're dealing with, then repeat it in all of your charts.

Marked as Answer by bej · Sep 27 2020
bej

Thanks, Jerry. Just what I was looking for. In 12c the option is just a text link, I'd looked at it several times without realizing it was clickable.

1 person found this helpful
1 - 2

Post Details

Added on Apr 18 2020
#database-key-features, #multitenant
1 comment
293 views