|
-
Primary Keys Issue on Remote Tables
have this query where i can check what are the primary keys on remote table.
select column_name from all_cons_columns where table_name='EMPLOYEES' and owner='BRENDAN';
COLUMNS_NAME
*************************
EMPLOYEE_ID
Now Question is
1. When we do copy tables does that also copy Primary keys because when i run the same query after copying tables it does not show any rows e,g,
select column_name from all_cons_columns where table_name='EMPLOYEES_COPY' and owner='TEST'
2. When we do copy does that also copy constraints?
Any help will be really appreciated.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|