Verify the number of constraints in the HR schema by running the following SQL query: Select CONSTRAINT_TYPE,COUNT(*) from dba_constraints where owner='HR'ĪND (CONSTRAINT_TYPE IN ('P','R')OR SEARCH_CONDITION_VC NOT LIKE '%NOT NULL%') The results of this query should be similar to the following: OBJECT_TYPE COUNT(*) Select OBJECT_TYPE, COUNT(*) from dba_OBJECTS where owner='HR' Verify the object types and count in HR Schema were created successfully by running the following SQL query. The script drops the user before creating it, which generates the error. You can ignore this error and run the script. When you run the script, you will get an error message indicating that user HR does not exist. In SQL Workbench/J, paste the SQL script in the Default.wksp window showing Statement 1. ![]() Open the provided SQL script in a text editor. ![]() Download the following archive to your computer: dms-sbs-RDSOracle2Aurora.zip.Įxtract the SQL script( Oracle-HR-Schema-Build.sql) from the archive.Ĭopy and paste the Oracle-HR-Schema-Build.sql file into your current directory.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |