8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Install Sample Schemas


Anonymous said...

perl -p -i.bak -e 's#/u01/app/oracle/product/12.2.0/dbhome_1/demo/schema/db-sample-schemas-12.2.0.1#'$(pwd)'#g' *.sql */*.sql */*.dat

this perl script doesnt work

Anonymous said...

SP2-0310: unable to open file "__SUB__CWD__/bus_intelligence/bi_main.sql"

Tim... said...

Hi.

The Perl command worked for me. You need Perl installed and in your path to be able to run it. If the Perl command didn't work for you, the rest won't. The command replaces "__SUB__CWD__" in all the scripts with the path of your choice. Without it, they will not work.

Cheers

Tim...

Anonymous said...

Tim means that you sould leave the string __SUB__CWD__ as is because the sed command replaces it with $(pwd).
Like you i did the mistake of replacing __SUB__CWD__ with my path and rectify this by changeing to the desired path and running the statement
as it is perl -p -i.bak -e 's#__SUB__CWD__#'$(pwd)'#g' *.sql */*.sql */*.dat

Anonymous said...

Tim running this in a multi teneant environment causes problems. Its to do with the users create connecting to the container.
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege

SP2-0640: Not connected

Tim... said...

Hi.

It works fine in multitenant. The example I give is for multitenant. Remember:

- Connect to system in the PDB to start.
- Use the EZ connect URL to the PDB in the command.

I emphasised this in the text.

Cheers

Tim...

venky said...

Works nicely in a multi-tenant .Thanks for the clear cut procedure as always.

Anonymous said...

Is there anything that you have created to create the Oracle sample schema in their autonamous cloud database? I would like to create a sample schema in their cloud environment. Now I have to run one script at a time.

Tim... said...

Hi.

I don't have a solution for that. Sorry.

Cheers

Tim...

Anonymous said...

perl -p -i.bak -e 's#__SUB__CWD__#'$(pwd)'#g' *.sql */*.sql */*.dat
This doesn't work on windows cmd even when I have installed ActivePerl. Can you provide one for windows

Tim... said...

Hi.

I had a quick play around with it, but I can't make it work either. There is something different about the way Perl handles file searches on Windows.

I'm sure it must be possible, but I'm not sure how. I'm not great at Perl.

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.