RE: Skipping a table on import (Using FGAC)

Suggestion: Investigate using FGAC. I just spent part of my day working on a solution to a very similar problem. I wanted to do a user level export but restrict the records from one table based on the value of a timestamp field. I did not want to have multiple exports. I originally considered a

Re: Skipping a table on import

how about giving where clause for the export of that table with " where 1=2", This way u will not have any records in export file . Bp - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, February 07, 2003 3:18 AM > Craig, > Assuming you don't

RE: Skipping a table on import

by:  <[EMAIL PROTECTED]>   [EMAIL PROTECTED] cc:               

RE: Skipping a table on import

<[EMAIL PROTECTED]To: > Multiple recipients of list ORACLE-L > om> > <[EMAIL PROTECTED]> >

RE: Skipping a table on import

If it is only 1 or 2 tables, maybe create those tables small and make maxextents = 1? Maybe put them in their own tablespace, then make it read only? Or take it offline? H. > -Original Message- > Is there a > way to skip > certain tables during an import? -- Please see the offici

RE: Skipping a table on import

ts of list ORACLE-L Sent by: <[EMAIL PROTECTED]> [EMAIL PROTECTED] cc: Subject: RE: S

RE: Skipping a table on import

"Craig Healey" <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L om> <[EMAIL PROTECTED]> Sent by: cc: [EMAIL

Re: Skipping a table on import

Sent by: cc: [EMAIL

RE: Skipping a table on import

0:59 > To: Multiple recipients of list ORACLE-L > Subject: Re: Skipping a table on import > > > Craig, > > you can export a owner without a table. > See the note : How to Export a Database > Bypassing a Table in Oracle7 and Oracle8 > at metalink. If you don't have a

RE: Skipping a table on import

Craig, Assuming you don't need the tables that you don't want to import the best option is to not export the tables by using a parameter file. (This speeds up the export, reduces the size of the dmp file, saves the backup/ftp time to copy the file to the target system and saves reading through th

Re: Skipping a table on import

Craig, you can export a owner without a table. See the note : How to Export a Database Bypassing a Table in Oracle7 and Oracle8 at metalink. If you don't have access to metalink send a email to me. But don't have any way to import Bypassing a table. I asked it to Oracle Suport at metalink and he

Skipping a table on import

Hi, I'm trying to import the live schema into a test schema, but 1 or 2 tables have a lot of data and it's taking hours. Is there a way to skip certain tables during an import? We're using 8.1.7 We have 400 tables, so I'd like to avoid having to list all the tables in the export statement. I have t