How to create an oracle dump(.dmp) file using Toad

oracle

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.

I can't use this 

C:\Users\kaunds_oliver>exp PORTAL_xxx/xxx@asdb 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?

Best Answer

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/xxx@//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. But is asdb is the SID and not the service name then you'd need to modify what you'd proposed. For example, create E:\Oliver\tnsnames.ora containing:

ASDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP) (HOST = 172.27.xx.xx) (PORT = 1530))
    )
    (CONNECT_DATA = (SID = asdb))
  )

then do:

set TNS_ADMIN=E:\Oliver\
exp PORTAL_xxx/xxx@asdb file=...

You should also consider using the data pump equivalent, expdp, if you're on 10g or higher, which puts the dump file on the server; and you can create the dump using the API calls rather than with the command line tool if you need to. Getting the dump file off the server might then be an issue - not sure if you're using exp for a reason, of course.

Related Question