by
3 6
0
3
238k
43
Top 1% !
Pearl of Wisdom
Specified
Popularity: 5960th place

Published on:

No tags for this snippet yet.
LicenseMIT_X11
OSWindows
SourceGitHub
Windows VersionWindows

Installing db-sample-schema in windows (https://github.com/oracle/db-sample-schemas)

Installing db-sample-schema in windows (https://github.com/oracle/db-sample-schemas): 
db-sample-schemas
Copy Embed Code
<iframe id="embedFrame" style="width:600px; height:300px;"
src="https://www.snip2code.com/Embed/553902/Installing-db-sample-schema-in-windows-(?startLine=0"></iframe>
Click on the embed code to copy it into your clipboard Width Height
Leave empty to retrieve all the content Start End
https://github.com/oracle/db-sample-schemas download the zip file and extract to "D:\app\rsrini7\product\12.1.0\dbhome_1\demo\schema" here rsrini7 is my username. extract the zip file to the dir according to your installation. open command prompt as administrator d: enter cd D:\app\rsrini7\product\12.1.0\dbhome_1\demo\schema mkdir log perl -p -i.bak -e 's#__SUB__CWD__#'D:/app/rsrini7/product/12.1.0/dbhome_1/demo/schema/'#g' *.sql */*.sql */*.dat (to install perl and other unix related tools - install babun - rocking tool for windows users. i love this ) edit mksample.sql and all '_main.sql' files and follow the below instructions this is required : http://www.dba-oracle.com/t_ora_65096_create_user_12c_without_c_prefix.htm 1. in connect statement add at the end 'as sysdba' 2. after the connect statement add the below line alter session set "_oracle_script"=true; type in the command prompt : sqlplus enter connect oracle with sys as sysdba and enter type the dba-password At final execute the below script from sql prompt @?/demo/schema/mksample <dba-password> <dba-password> password password password password password password EXAMPLE TEMP D:/app/rsrini7/product/12.1.0/dbhome_1/demo/schema/log/ replace <dba-password> with the actual dba password happy learning:)
If you want to be updated about similar snippets, Sign in and follow our Channels

blog comments powered by Disqus