Question: 1 - Create a pluggable databases pdb 3 with script. 2 - Create user 1 and user 2 with necessary privileges to create / insert

1- Create a pluggable databases pdb3 with script.
2-Create user1 and user2 with necessary privileges to create/insert/update table t1 and t2 respectively.
3- Create two tablespaces tbs1 and tbs2 for user1 and user2 respectively.
4- Create table tbs1.t1 and tbs2.t2 where t2 has a foreign key referencing t1.
5-Insert into t110 rows where 5 rows with location Riyadh and 5 rows with location Jeddah.
6-Allow user2 to select rows from user1.tbs1.t1 with location=Riyadh

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!