Forum Stats

  • 3,853,698 Users
  • 2,264,256 Discussions


Few user backup is not coming with Export Data Pump command


I have used the below command to take full database backup

expdp 'username/password as sysdba' DIRECTORY=OracleDB_Backup  DUMPFILE=Oracle_DB_Backup"%date:~7,2%%date:~4,2%%date:~10,4%".dmp LOGFILE=log_Oracle_DB_Backup"%date:~7,2%%date:~4,2%%date:~10,4%".log full=y

All the database backup are coming properly.

But when I'm creating any new user and adding tables in it including data, and after that, I run this command so that the latest user backup is not coming.

Please let me know why I'm getting this issue and is there any possible solution for this.

Also, I have attached the log file below.