Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Sunday, September 20, 2015

Install demo schemas in 11gR2:


Install demo schemas in 11gR2:


SHAIKDB>@?/demo/schema/mkplug

specify password for SYS as parameter 1:

specify password for HR as parameter 2:

specify password for OE as parameter 3:
Enter value for 3: oe

specify password for PM as parameter 4:
Enter value for 4: pm

specify password for IX as parameter 5:
Enter value for 5: ix

specify password for  SH as parameter 6:
Enter value for 6: sh

specify password for  BI as parameter 7:
Enter value for 7: bi

specify INPUT metadata import file as parameter 8:
Enter value for 8: /u01/app/oracle/product/11.2.0.2/SHAIKPROD/assistants/dbca/templates/example.dmp

specify INPUT database backup file for tablespace EXAMPLE as parameter 9:
Enter value for 9: /u01/app/oracle/product/11.2.0.2/SHAIKPROD/assistants/dbca/templates/example01.dfb

specify OUTPUT database file for tablespace EXAMPLE as parameter 10:
Enter value for 10: /u01/app/oracle/shaikdb/example02.dbf

specify OUTPUT log directory as parameter 11:
Enter value for 11: /u01/app/oracle/shaikdb/demo.log

No comments: