Toad Tutorial For Beginners Pdf
We can export the entire database schema(skeleton) along with its data in one.dmp file using oracles 'exp' tool. But how do I do it using Toad only.
How To Use Toad Sage In Shinobi Life
I can't use this C: Users kaunds_oliver>exp PORTAL_xxx/[email protected] file=E: Oliver userexpo rt.dmp log=E: Oliver userexport.log As there is no entry in the TNSNAMES.ora for the remote server ='asdb' Also, I tried doing this ASDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 172.27.xx.xx) (PORT = 1530)) ) (CONNECT_DATA = (SERVICE_NAME = asdb)) ) But I don't have the privileges to edit anything in C Drive i.e. The TNSNAMES.ora file How do I create a dump file using specifically 'Toad' tool of a database that I am connected to remotely? Not directly answering the question as I don't use Toad, but you can use exp without a tnsnames.ora by using the 'easy connect' syntax for the connection string, at least in recent versions: exp PORTAL_xxx/[email protected]//172.27.xxx.xxx:1530/asdb file=. Where asdb is the database service name registered with the listener. You can also create your own tnsnames.ora in a different directory and set the TNS_ADMIN environment variable to that directory path.