while designing tables what are the precaution that are taken to ensure that the same information is not stored in more than one place. What is the advantage of doing this?
Answers
Answered by
4
Answer:
To create a new table in your schema, you must have the CREATE TABLE system privilege. To create a table in another user's schema, you must have the CREATE ANY TABLE system privilege. Additionally, the owner of the table must have a quota for the tablespace that contains the table, or the UNLIMITED TABLESPACE system privilege.
Create tables using the SQL statement CREATE TABLE.
Explanation:
Similar questions