[prev in list] [next in list] [prev in thread] [next in thread] 

List:       suse-oracle
Subject:    Re: [suse-oracle] exp80
From:       Ahbaid Gaffoor <ahbaid.gaffoor () placemark ! com>
Date:       2002-11-28 4:06:22
[Download RAW message or body]


Yeah, I tried to use a view too.. didn't work either...

I haven't tried this, but if you're willing to.. try creating a 9i 
database as small as possible, then create database links to your 8.0 db.

Then create synonyms in the 9i db for the 8.0 objects....

That way you can connect to the 9i db for exports....

Don't know if it will work, just a theory.....

If it does please let us know...

thanks,

Ahbaid.

Muhammad F. Adam wrote:

>Thank you very much for the answers. I also think about it. That will be
>effective if I only have few of tables. But in my office, I have to deal
>with so many tables. I don't want to create additional tables to hold the
>subset table data because of space issue.
>
>The solution is I work with our developer to create an API to synchronize
>both tables (source and target) and doing this on downtime. Of course We
>have to minimalize the downtime.
>
>mfa
>ps: creating a view with query doesn't help. Exp80 (and exp) only recognize
>tables, not views.
>
>-----Original Message-----
>From: Ahbaid Gaffoor [mailto:ahbaid.gaffoor@placemark.com]
>Sent: Wednesday, November 27, 2002 10:32 PM
>To: Muhammad F. Adam
>Cc: suse-oracle@suse.com
>Subject: Re: [suse-oracle] exp80
>
>
>create table SUBSET_TABLE
>as select * from MAIN_TABLE
>where <your_query>;
>
>then export your SUBSET_TABLE.
>
>
>When you import, you can probably create a trigger on SUBSET_TABLE to 
>load the data into MAIN_TABLE
>
>or
>
>truncate SUBSET_TABLE
>import....
>insert into MAIN_TABLE select * from SUBSET_TABLE;
>
>Muhammad F. Adam wrote:
>
>  
>
>>Dear all,
>>
>>Sorry, OOT.
>>I wan to export a subset of a table using exp80 (because my DB version is
>>8.0.5). How can I do this? I usually use exp with query parameter, but with
>>exp80 I'm unable to do that because query parameter is not recognized by
>>exp80.
>>
>>Warm regards,
>>
>>
>>mfa
>>
>> 
>>
>>    
>>
>
>  
>

-- 
Ahbaid Gaffoor
Database Administrator - Oracle Certified Professional
-------------------------------------------------------------------
Wrk:972-404-8100x14 Cell:469-323-9420 Pgr:214-248-6322 ICQ:67367930
Pager email:  pageahbaid@placemark.com/2142486322@airmessage.net





[prev in list] [next in list] [prev in thread] [next in thread]