Unable to export schema fue to ORA 00092 get schema size info

Hello Experts,

I am trying to export a DB schema but I am receiving ORA 00942 "get schema size info".

I need to backup a copy of a schema before reinstalling the HW. I have performed a cold backup but would still like to have a schema export done.

Google gives some ambigous explanation for this error and very little help on the steps to actually fix it.

Any help will be appreciated.

Regards


FABRICIO76Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
gopiseraConnect With a Mentor Commented:
Yeah, Hoping this problem exists due to the privilege issue mainly.

Or run as an root user and check.
0
 
Aaron ShiloChief Database ArchitectCommented:
hi

you LARGE_POOL_SIZE must be greater than LARGE_POOL_MIN_ALLOC

check the size of the  LARGE_POOL_MIN_ALLOC and set the  LARGE_POOL_SIZE
toa higher value.
 
0
 
FABRICIO76Author Commented:
Hello Ashilo,

I am increasing the memory setting and testing immediately.

Thanks

F
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
FABRICIO76Author Commented:
Hello Ashilo,

We are still seeing the same error, even after increasing the memory from a small sized template to a large.

Any further ideas?

Thanks
2011-03-21-141924.png
0
 
Aaron ShiloConnect With a Mentor Chief Database ArchitectCommented:
hi

the error you display in the screenshot is an error
regarding the actual exsistance of the table .

1. are you using the owner of the table ?
2. use fully qualified names schemaname.objectname
3. make sure you have privileges to access the table.
0
 
schwertnerConnect With a Mentor Commented:
This means that the schema or the table doesn't exist in the database.
As mentioned over this could be typo, lack of privilige to access the schema/table, or even wrong database.
0
 
FABRICIO76Author Commented:
Hello Experts,

Thank you for your help.

Indeed it was lack of privileges, I applied the following scripts and re tested succesfully.

I am splitting the points since all pin pointed that this could be privileges.

grant exp_full_database to myuser;
grant imp_full_database to myuser;
0
All Courses

From novice to tech pro — start learning today.