Oracle does not export all tables

Asked

Viewed 367 times

0

I am performing an export by database at a time 11.2.0.1.0 but when checking the log I realize that the tables that have no record are not exported.

command I’m using to export the database
exp system/senha owner=freitechnew file=freitechnew.dmp log=freitechnew.log compress=N

Someone’s been through this trouble?

database oracle export

  • Could add to the command FULL=Y at your command. Because in the Oracle documentation, they give a basic example like this: exp user@DB FULL=Y FILE=PATH_TO_DUMPFILE

  • When exporting with the user it returns the error EXP-00008: Erro Oracle: 1406 encontrado and does not export, I will try to solve this ora-1406 to see if I can export so, thank you for now.

1 answer

-1

if Voce specifies the Owner it only takes this Owner, to make the whole bank use as below.

Exp system/password file=freitechnew.dmp log=freitechnew.log full=y compress=N

Browser other questions tagged database oracle export

You are not signed in. Login or sign up in order to post.