Re: Oracle8 and SAP

From: Ted Knijff <knijff_at_bigfoot.com>
Date: Sat, 09 Jun 2001 18:02:10 GMT
Message-ID: <3b226263.40212162@news.online.de>

Hallo Michael,

If I understand you correctly, you have a Q-machine and want to import some tables from your P-machine. Either you will have to do it by hand, selecting the tables in the import utility with TABLES=.... or use the SAP tools. You could :

- export the entire DB from your P-box
- export the entire DB from your Q-box
- import the entire P-export to the Q-box
- delete/drop what you don't need on the Q-box
- selectively import the Q-export to the Q-box and 

  overwrite (IGNORE=Y)
    or
  use the SAP transport facilty to update your customization.

You will have a few long evenings ahead of you.. ;-)

Ted
www.aisys-ag.de

On Fri, 08 Jun 2001 18:00:13 GMT, Jerry Metz <jmetz1_at_ix.netcom.com> wrote:

>This is a multi-part message in MIME format.
>--------------1AA93ECD81C8B19238D1DA41
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>If I understand your question, you can export the table structures without
>exporting the rows of data. Check the Utilities manual for the syntax.
>
>Michael Stupp wrote:
>
>> I want to copy my Oracle 8.0.5.2 Database with SAP 4.0B from my main system
>> to my (existing)quality system without
>> deleting the quality database but with deleteing the data in the quality
>> database.
>> Any ideas if export/import works when I use the "destroy" clause with the
>> import-command?
>>
>> Please mail to: michael.stupp_at_dieffenbacher.de
>
>--------------1AA93ECD81C8B19238D1DA41
>Content-Type: text/x-vcard; charset=us-ascii;
> name="jmetz1.vcf"
>Content-Transfer-Encoding: 7bit
>Content-Description: Card for Jerry Metz
>Content-Disposition: attachment;
> filename="jmetz1.vcf"
>
>begin:vcard
>n:Metz;Jerry
>tel;fax:847-215-4772
>tel;work:847-215-4771
>x-mozilla-html:FALSE
>org:G.L. Metz & Associates
>adr:;;;Buffalo Grove;IL;60089;USA
>version:2.1
>email;internet:JMetz1_at_ix.netcom.com
>title:Director, Consulting
>fn:Jerry Metz
>end:vcard
>
>--------------1AA93ECD81C8B19238D1DA41--
>

EMail: knijff_at_bigfoot.com Received on Sat Jun 09 2001 - 13:02:10 CDT