| Export problem..its urgent [message #72912] |
Mon, 08 December 2003 03:21  |
Neha
Messages: 20
Registered: July 2000
|
Junior Member |
|
|
Hi friends
Its really urgent so any help will be appreciated.
I want to know that if a user that has been provided only views on certain tables is exported then the tables on which the views were made will also be exported. And what about the synonyms? one more thing how do I can come to know if I have DBA privilege that on which tables the views were made?
Any assistance will be appreciated.Its urgent..so pls help quickly.
Bye
thanks and rgds
Neha
|
|
|
|
| Re: Export problem..its urgent [message #72913 is a reply to message #72912] |
Tue, 09 December 2003 02:43  |
naveen dutt
Messages: 8
Registered: December 2003
|
Junior Member |
|
|
Hi neha,
Views only contains select statement not the data. Data is only store in table.
Export can be taken on three ways
1) Full
2) User wise
3) Table wise
To list on which tables views are created there is one data dictionary view
DBA_VIEWS
Naveen Dutt
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
