Edit the DBTUNE table

DBTUNE table in SDE schema stores the DBTUNE storage parameters that control how ArcSDE clients create objects within an Oracle database. The table is populated with specific default values. sdedbtune utility is used to initialize or alter DBTUNE table contents.

To edit the DBTUNE table, the following steps can be followed:

1. Use "sdedbtune -o export" to export the DBTUNE table to a text file.
sdedbtune -o export -f dbtune_out.sde -i 5151 -s sdeserver -u sde -p password

ArcSDE 9.1 Oracle10g Build 371 Tue May 9 10:13:38 PDT 2006Attribute Administration Utility-----------------------------------------------------
Successfully exported to file SDEHOME\etc\dbtune_out.sde on server sdeserver

2. Edit the resulting file with vi (UNIX) or Notepad (Windows).

3. Use "sdedbtune -o import" to import the modified file into DBTUNE table.

sdedbtune -o import -f dbtune_out.sde -i 5151 -s sdeserver -u sde -p password

ArcSDE 9.1 Oracle10g Build 371 Tue May 9 10:13:38 PDT 2006Attribute Administration Utility-----------------------------------------------------
Import DBTUNE Table. Are you sure? (Y/N): y
Successfully imported from file SDEHOME\etc\dbtune_out.sde

4. Test. Always.

sdedbtune tool in ArcSDE 9.1 always exports and imports from the $SDEHOME/etc directory. In ArcSDE 9.2, the tool picks up the directory the command is issued if no directory is specified with the path name.

Some of my published translation books

Microsoft.NET Compact Framework技术内幕

http://www.tup.tsinghua.edu.cn/book/SHOWBOOK.asp?cpbh=012299-01
http://www.amazon.cn/detail/product.asp?ref=DT_RV&uid=000-0000000-0000000&prodid=zjbk205043
Note: I am one of the translators of the book, not the author.


精通Asp.NET程序设计

http://www.tup.tsinghua.edu.cn/book/Showbook.asp?csbh=76&CPBH=009461-01
http://www.amazon.cn/detail/product.asp?prodid=zjbk367284&ref=SR&uid=168-7234512-8780244
Note: I am the translator, not the author.

Here I Come

This is my first post. So it is a good chance for me to write about this blog. My intention is to share my knowledge and idea about the stuff I am practicing every day, learning every day and thinking every day. It has nothing to do with my employers. Hopefully it will create a friendly web community for my friends.