[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

how to use defncopy?

Posted on 1997-09-02
1
Medium Priority
?
2,025 Views
Last Modified: 2012-05-04
I am trying to use "defncopy to copy out | in the view, rules, default and triggers from one database to another.

for example
defncopy -Usa -P out /tmp/pb_cattbl.dcopy hf_prod pb_cattbl

What' wrong for the above statement?
0
Comment
Question by:edward97
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 2

Accepted Solution

by:
Srw earned 100 total points
ID: 1098019
Your syntax appears fine.
Without knowing what exactly the problem is, it's hard to help, but...

1. Maybe the /tmp directory doesn't exist or have enough space.
2. If you're running this on a workstation, you may need to include the -S option (server name).
3. I'm sure you checked this one, but perhaps the DB name or object name is misspelled.
4. The Sybooks help says that defncopy won't work with objects created with Report Workbench
5. I'm just guessing, but pb_cattbl looks like a powerbuilder utility object.  You may not need to copy it.  Just get PB to create a new one.
0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

Sometimes Administrators rights are not enough. These cases call for the SYSTEM account. The process in this article outlines the steps required to execute commands using the SYSTEM account.
What monsters are hiding in your child's room? In this article I will share with you a tech horror story that could happen to anyone, along with some tips on how you can prevent it from happening to you.
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

656 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