I'm trying to understand what I have in my Windows installation vs. this "Sample Schemas
" link, plus I want to create my own custom schema and not sure about tablespace setup.
Here's what is in my "demo\schema" folder:
The documentation refers to
a master script (mksample.sql) which I don't seem to have.
Plus the documentation refers to the following schemas, which are slightly different than what's in my "demo\schema" folder (I don't have PM or IX schema). And I have the Business_Intelligence schema that's not in the documentation.
Plus, I don't have "hr_main.sql" as referenced in the documentation. I only have one HR file, "hr_code.sql", attached. So where are the HR tables ? data ?
So I need a little help in understanding this. Also, if I got the schema's set up, where's the data ? I don't see where is the data.
In regard to setting up a custom schema, I see this command:
CREATE USER smithj
IDENTIFIED BY pwd4smithj
DEFAULT TABLESPACE tbs_perm_01
TEMPORARY TABLESPACE tbs_temp_01
QUOTA 20M on tbs_perm_01;
but I assume I first have to set up the tablespace(s)
? I've never done this . . .