Home » SQL & PL/SQL » Client Tools » Backup using toad
Backup using toad [message #684333] Tue, 11 May 2021 19:07 Go to next message
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 #684334 is a reply to message #684333] Wed, 12 May 2021 00:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

If you don't tell us what are these warnings we can't help.
And first, is this really a database backup or an export?

[Updated on: Wed, 12 May 2021 00:25]

Report message to a moderator

Re: Backup using toad [message #684342 is a reply to message #684334] Wed, 12 May 2021 05:23 Go to previous messageGo to next message
Qas313
Messages: 9
Registered: May 2021
Junior Member
Sorry dear its export... i dont knw the warning i checked the toad log file and the file created with export utility as well... nothing mentioned there.. jst shown at the end that export terminated successfully with warnings.. and its for specific user and its schema
Re: Backup using toad [message #684343 is a reply to message #684342] Wed, 12 May 2021 05:24 Go to previous messageGo to next message
Qas313
Messages: 9
Registered: May 2021
Junior Member
I mean i export schema of specific user by using toad application
Re: Backup using toad [message #684344 is a reply to message #684343] Wed, 12 May 2021 05:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

If you don't know what are the warnings we don't either, so can't tell more.

Re: Backup using toad [message #684347 is a reply to message #684344] Wed, 12 May 2021 12:10 Go to previous messageGo to next message
Qas313
Messages: 9
Registered: May 2021
Junior Member
How would i knw about the warning i mean from where i get info as log files do not contain such info... and sorry to bother u dear i faces a problem and share on group... thanx for your arrogant reply...

Regards,
Re: Backup using toad [message #684348 is a reply to message #684347] Wed, 12 May 2021 13:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What is "arrogant" in my reply?

Re: Backup using toad [message #684349 is a reply to message #684348] Wed, 12 May 2021 14:18 Go to previous message
Littlefoot
Messages: 21690
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>
It says that SYS owns directory (Oracle object) whose name is EXT_DIR and it points to filesystem directory C:\TEMP which resides on my laptop, as it serves as a database server for my 11gXE database. You should see something similar.
Previous Topic: ORA-24373 invalid length specified for statement (spllt)
Next Topic: Oracle instance Shutdown
Goto Forum:
  


Current Time: Wed Dec 01 09:28:02 CST 2021