⟩ What Are the Restrictions on External Table Columns?
When creating external table columns, you need to watch out some restrictions:
► "PRIMARY KEY" is not allowed.
► "NOT NULL" is not allowed.
► "DEFAULT value" is not allowed.
Question and Answer:
Home Oracle Database
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
List five most important parameter in 9i affecting performance?
What is PGA_AGGREGATE_TARGET?
How do you analyze table partition using Oracle provided package?
You see a wait on LMS process in statspack, what does that mean?
Explain procedure to Change CHARACTERSET of a database.
If you had a tablespace, TEST_TABLESPACE, which consists of three files TEST01.dbf, TEST02.dbf, and TEST03.dbf, and someone accidentally used the Unix command "rm" to delete the file TEST02.dbf, what else would you need in order to recover all the data that was present in TEST_TABLESPACE at the time that TEST02.dbf was deleted?
How do you put database is ARCHIVELOG mode, explain procedure?
How can you tell if an index on particular table is USED or NOT USED in 9i?
Explain FORCE LOGGING feature in 9i.
Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
