The forum will be down for maintenance at some point from Friday, November 16 at 19:00 EDT until Sunday, November 18 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

I'm converting ASA9 database to SA11.

This database have 4 dbspaces (main +3), after all process, extra dbspace files, have dbR extension. Is it safe to just rename to .db ?

asked 28 Sep '11, 08:34

Zote's gravatar image

Zote
1.7k364050
accept rate: 43%

edited 28 Sep '11, 08:35


Yes, it is safe to rename the dbspaces to have any name you would like but when you do so you need to also execute an "ALTER DBSPACE RENAME ..." statement for each dbspace to tell the database server the new name of each file.

permanent link

answered 28 Sep '11, 08:55

Mark%20Culp's gravatar image

Mark Culp
23.8k9134279
accept rate: 40%

Thank you Mark. And can you tell me why file name ends with R?

(28 Sep '11, 14:45) Zote
Replies hidden
2

The dbspaces get assigned an extension of "dbR" so as to not conflict with the original file name's extension (typically "dbs") - in case the new file is in the same directory as the original file - and to make it obvious which files are the new "rebuilt" dbspaces. This is explained in the docs: http://dcx.sybase.com/1201/en/dbadmin/dbunload.html

(28 Sep '11, 14:55) Mark Culp
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×105
×49
×22
×21
×21

question asked: 28 Sep '11, 08:34

question was seen: 2,635 times

last updated: 28 Sep '11, 14:55