?
Solved

sybase 12.5 change database device mapping

Posted on 2011-10-07
1
Medium Priority
?
326 Views
Last Modified: 2012-06-27
experts,

I had to recreate my database devices and increase the size of them. I then created my database for load, and reloaded my database back onto the new devices. now my log, index, and data devices are all mapped to the wrong segments. How can I fix this?

Thanks in advance.
0
Comment
Question by:telliot79
1 Comment
 

Accepted Solution

by:
telliot79 earned 0 total points
ID: 36933893
figured it out. you can do it using drop and extend sps.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A metadevice consists of one or more devices (slices). It can be expanded by adding slices. Then, it can be grown to fill a larger space while the file system is in use. However, not all UNIX file systems (UFS) can be expanded this way. The conca…
Installing FreeBSD… FreeBSD is a darling of an operating system. The stability and usability make it a clear choice for servers and desktops (for the cunning). Savvy?  The Ports collection makes available every popular FOSS application and packag…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses
Course of the Month17 days, 5 hours left to enroll

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question