Hi to all,
I'm not a DBA and I'm very basic level with oracle database techology. I want to study for get OCA "SQL Fundametals I" certification.
For this reason I have downloaded the "pre built" virtualbox machine with oracle database 11g r2 installed but I not found the SAMPLE schema HR and OE used as study case for the certification.
Googling on internet I found that is possible install the sample schema manually.
In the $ORACLE_HOME/demo/schema I found the mkplug.sql. Running this file with sqlplus I insert the 11 ask parameters but the HR, OE and other sample schema are not create correctly.
The error that I get by seeing in the log file is: ORA-00959: tablespace 'EXAMPLE' does not exist.
Please, can anyone help me on what are the exact steps to do before run the mkplug.sql file?
Searching on internet I found that the solution is this: Either we create tablespace EXAMPLE in the target database or we use the datapump REMAP_TABLESPACE option to redirect the objects to a different tablespace.
But i do not know as to do it. Please, can anyone tell me step to step in simply way what I have to do?
thanks in advance.