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-188.8.131.52#'$(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"
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.
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
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.
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.
I don't have a solution for that. Sorry.
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
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.
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.