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.3k9132275
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:

×101
×45
×22
×20
×18

question asked: 28 Sep '11, 08:34

question was seen: 2,281 times

last updated: 28 Sep '11, 14:55