| Backup using toad [message #684333] |
Tue, 11 May 2021 19:07  |
 |
Qas313
Messages: 9
Registered: May 2021
|
Junior Member |
|
|
Hi Dear All,
I took backup using toad but it is terminated successfully with warnings... as my database is distributed and on some sites it is without warning and on some sites completed with warning... can anybody guide me or help me in this regard?
Regards,
Qaisar
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Backup using toad [message #684349 is a reply to message #684348] |
Wed, 12 May 2021 14:18  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
If you used [Database - Export - Data Pump Export], then its Files tab contains
- directory (you have to have access to)
- dump file name (.dmp)
- log file name (.log)
If you specified those values (you should have), then you'd find both .DMP and .LOG files in the same filesystem directory (which usually resides on the database server, while Oracle object "directory" points to it. Therefore, have a look, now that you know where it is. How to find that info? Run the following statement:
SQL> select * From all_directories;
OWNER DIRECTORY_NAME DIRECTORY_PATH
------ -------------------- --------------------
SYS EXT_DIR c:\temp
SQL> |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
