Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SCOTT/TIGER

Beauty_and_dBestJun 16 2017 — edited Jun 16 2017

Hi ALL,

11g 12c

I want to teach basic sqlplus.

Then, I want to create demo user scott/tiger.

Where do I get the scripts to create all the demo tables?

I saw some sample scott/tiger tables, like below

SQL> select table_name from user_tables;

TABLE_NAME

--------------------------------------------------------------------------------

DEPT

EMP

EMP_SNAPSHOT

MLOG$_EMP

RUPD$_EMP

What module in sqlplus do snapshot objects belong to? Do they belong to an sqlplus topic or more advanced?

Please help...

Kind regards,

jc

This post has been answered by SUPRIYO DEY on Jun 16 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 14 2017
Added on Jun 16 2017
5 comments
448 views