Re: export/import questions

Hardy,

Comments inline.

> 1. I'm fairly familiar with "imp"ort and "exp"ort, and I've been using
> export to export an entire user space. Up 'till now, I've been
> "imp"orting the entire user space to another machine to make a mirror
> image on that other machine. On the "target" machine for the import, I
> now need to import the whole user space *except* for 1 table - I need to
> keep this one table intact on the target machine - is this possible
> using import? Or, is there another more flexible method for backing up
> and restoring Oracle databases/users/tables other than export/import?

From what I gather, you can do one of two things:

1. Import the entire user and then drop the one table you do not want or
2. Use TABLE mode import and list all of the tables that you want to import

> 2. Is it possible to "imp"ort sequences when also using the "tables=a,
> b, c" import parameter? Seems like sequences are imported when
> importing an entire userspace, but not when importing individual
> tables. Looks to me like there is no "sequences=Y" parameter - am I
> missing something?

There is nothing like the SEQUENCES=Y parameter. You'll either have to do a full import or a user import. Alternatively, you can use the SHOW=Y option to show what the import will perform along with the FROMUSER and LOG options (to capture the output of the SHOW=Y). Then you'll have the DDL commands to create the sequences. Use this information to create a script which you can run to create your sequences.

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================