how can db_files > maxdatafiles since db_files is for
instance and the later is for database
No Answer is Posted For this Question
Be the First to Post Answer
What is a OUTER JOIN?
What is control file used for?
How to view all columns in an existing table?
How to work with data objects interactively?
What is a table index in oracle?
Is a rollback possible to any savepoint?
How to estimate disk space needed for an export job?
How can I introduce multiple conditions in like operator?
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?
After update how do u know how many records got updated
What are joins..how many types of joins are there?
29 Answers Amdocs, CSC, TCS,
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here