Hi,
I am new to Oracle...
Is using the "Export Tables" feature from PL SQL same as running the "exp" command? Do I have to log in as a SYSDBA or is it OK to log in as schema owner? If my goal is to copy the exact database environment to a different server, is using "Export Tables" enough?
And is there a way to export other user objects (i.e. views, procedures) besides tables? There is "Export User Objects" feature in PL-SQL, but this doesn't include the data.
Thank you for your help!
I am new to Oracle...
Is using the "Export Tables" feature from PL SQL same as running the "exp" command? Do I have to log in as a SYSDBA or is it OK to log in as schema owner? If my goal is to copy the exact database environment to a different server, is using "Export Tables" enough?
And is there a way to export other user objects (i.e. views, procedures) besides tables? There is "Export User Objects" feature in PL-SQL, but this doesn't include the data.
Thank you for your help!