Home » SQL & PL/SQL » SQL & PL/SQL » database samples ???
database samples ??? [message #239020] Mon, 21 May 2007 05:09 Go to next message
cefb
Messages: 56
Registered: March 2007
Member
Hii

anyone knows where i can find oracle database demos like, hr,pm,oc,oe or other samples??



thanks
Re: database samples ??? [message #239031 is a reply to message #239020] Mon, 21 May 2007 05:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
$ORACLE_HOME/demo/schema

Regards
Michel
Re: database samples ??? [message #239034 is a reply to message #239020] Mon, 21 May 2007 05:37 Go to previous messageGo to next message
cefb
Messages: 56
Registered: March 2007
Member
but i only got human resources sample.
Re: database samples ??? [message #239041 is a reply to message #239034] Mon, 21 May 2007 05:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
C:\Oracle\Ora102\demo\schema>dir /o:e /o:n
 Volume in drive C has no label.
 Volume Serial Number is 647F-53FF

 Directory of C:\Oracle\Ora102\demo\schema

25/01/07  01:16 PM    <DIR>          .
25/01/07  01:16 PM    <DIR>          ..
24/05/06  10:17 AM    <DIR>          bus_intelligence
24/05/06  10:17 AM    <DIR>          human_resources
24/05/06  10:17 AM    <DIR>          info_exchange
24/05/06  10:11 AM    <DIR>          log
25/01/07  01:15 PM    <DIR>          order_entry
24/05/06  10:18 AM    <DIR>          product_media
24/05/06  10:17 AM    <DIR>          sales_history
24/05/06  10:17 AM    <DIR>          shipping
10/05/05  10:09 PM            15,784 sted_mkplug.sql.dbl
07/06/04  04:42 PM             1,515 mk_dir.sql.sbs
03/04/03  09:54 AM             5,254 mksample.sql.sbs
25/01/07  01:16 PM             1,603 mk_dir.sql
10/05/05  10:09 PM            27,997 mkplug.sql
25/01/07  01:16 PM             5,384 mksample.sql
10/05/05  10:09 PM             5,258 mkunplug.sql
23/09/04  01:54 PM             4,990 mkverify.sql
08/12/03  04:49 PM             4,502 README.txt

They are all there.

Regards
Michel
Re: database samples ??? [message #239043 is a reply to message #239020] Mon, 21 May 2007 05:54 Go to previous messageGo to next message
cefb
Messages: 56
Registered: March 2007
Member
but not in my installation.


Directory of C:\Oracle\Ora92\demo\schema

03/09/2007  03:18 PM    <DIR>          .
03/09/2007  03:18 PM    <DIR>          ..
03/09/2007  03:09 PM    <DIR>          human_resources
03/09/2007  03:09 PM    <DIR>          log
03/09/2007  03:18 PM             4,447 mksample.sql
03/09/2007  03:09 PM             1,624 mk_dir.sql
03/25/2002  12:25 PM             3,930 README.txt
               3 File(s)         10,001 bytes
               4 Dir(s)  48,087,953,408 bytes free



can you send me the content of order_entry folder?

[Updated on: Mon, 21 May 2007 05:55]

Report message to a moderator

Re: database samples ??? [message #239052 is a reply to message #239043] Mon, 21 May 2007 06:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For 9.2 you should have:
C:\Oracle\Ora920\demo\schema>dir /o:e /o:n
 Volume in drive C has no label.
 Volume Serial Number is 647F-53FF

 Directory of C:\Oracle\Ora920\demo\schema

24/05/06  08:40 AM    <DIR>          .
24/05/06  08:40 AM    <DIR>          ..
24/05/06  08:22 AM    <DIR>          human_resources
24/05/06  08:23 AM    <DIR>          log
24/05/06  08:22 AM    <DIR>          order_entry
24/05/06  08:25 AM    <DIR>          product_media
24/05/06  08:23 AM    <DIR>          sales_history
24/05/06  08:22 AM    <DIR>          shipping
24/05/06  08:34 AM             1,408 mk_dir.sql.bak
24/05/06  08:40 AM             1,408 mk_dir.sql
24/05/06  08:25 AM             4,452 mksample.sql
25/03/02  11:25 AM             3,930 README.txt

Launch again OUI (C:\Program Files\Oracle\oui\install\setup.exe) and try to see if there is any option to reinstall demo scripts.

Regards
Michel
Re: database samples ??? [message #239053 is a reply to message #239020] Mon, 21 May 2007 06:18 Go to previous message
cefb
Messages: 56
Registered: March 2007
Member
ok. thanks
Previous Topic: Stored Procedure in oracle
Next Topic: SELECT QUERY
Goto Forum:
  


Current Time: Mon Dec 05 07:10:25 CST 2016

Total time taken to generate the page: 0.10715 seconds