Francesco Mantovani
Francesco Mantovani

Reputation: 12357

Oracle Sample HR schema :: specify default tablespeace for HR as parameter 2

I have downloaded Oracle Database Sample Schemas from GitHub and I'm following the official guide about how to import the HR schema manually.

Oracle SQL Developer prompt me with this banner: Enter value for 2:

enter image description here

Which is caused by the lines:

PROMPT specify default tablespeace for HR as parameter 2:
DEFINE tbs      = &2

Now.

Being an official guide for newbies I expect at least an explication about the value I need to enter.

Especially because Oracle is providing the data so they must know if the default value should be 2, 200, 2000, etc..

Upvotes: 0

Views: 1301

Answers (1)

MT0
MT0

Reputation: 168361

You need to supply the name of a TABLESPACE; this is specified in the instructions in the README.md file in the Github repository:

Use your current SYSTEM and SYS passwords, and also your actual default and temporary tablespace names. The passwords for the new HR, OE, PM, IX, SH and BI users will be set to the values you specify.

If you have not got an existing TABLESPACE that you want to use then you need to create one using the CREATE TABLESPACE command.

I.e. one example is:

CREATE TABLESPACE tbs_01 DATAFILE 'tbs_f2.dat' SIZE 40M ONLINE;

Then, if you didn't have an existing tablespace you wanted to use and had used the above command, the value you would need to provide is: tbs_01

Upvotes: 1

Related Questions