DBTune parameter on Multiple Enterprise Geodatabase ArcSDE 10.1

Question

Hi All,
I'm working with Oracle 11.2, ArcSDE 10.1 and ArcGIS 10.1 and I have created multiple enterprise geodatabase from Arc Catalog. It means I have 10 enterprise geodatabase and one SDE enterprise geodatabaseall, all have its own user administrator.

My requirement is, I have to separate the index tablespace and data tablespace by editing DBtune file for each enterprise geodatabase.

In case of SDE, there is no problem I can export and import the edited dbtune file. But in case of other 10 Enterprise geodatabase only export command is working, if I want to import edited dbtune file using sdedbtune command it gives me error "insufficient privileges".

Need an expert advice. Please its urgent.

Thanks in Advance

Amit

TravisVal · Answer

Your welcome, I am happy I was able to help.

Travis

AmitGupta · Answer

Thank you very much Travis.
Your reference code is working and I can import modified dbtune file for another user. Actually i was forgetting to add full service name path -i sde:oracle11g:myserver:user.

Once again Thank u very much for your support.

Amit

TravisVal · Answer

Can you post the command you are trying to use?

It worked for me using the following:sdedbtune -o import -f ..\etc\dbtune.sde -u sde2 -p *** -i sde:oracle11g:myserver/orcl:sde2

Travis