Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: HELP please - Import Of Sequences ONLY

RE: HELP please - Import Of Sequences ONLY

From: Philip West <P.West_at_g-icap.com>
Date: Tue, 8 Aug 2000 10:33:54 +0100
Message-Id: <10583.114046@fatcity.com>


If you run a full import with rows=n and ignore=y the import will create all exported objects that do not exist in the new database. This includes tablespaces,users, grants, segments, sequences, etc. etc.

Phil West
Unix Sys Admin and Oracle Financials DBA +44 (0) 20 7623 5222 x5221

-----Original Message-----
From: VIVEK_SHARMA [mailto:vivek_sharma_at_inf.com] Sent: 08 August 2000 09:53
To: Multiple recipients of list ORACLE-L Subject: HELP please - Import Of Sequences ONLY

After Importing from an Export Dump into an NEWly Created Database by Specifying the individual TABLE Names (TABLES parameter) , NO Sequences have Got imported

How can the Sequences be imported/Obtained from the Export Dump ?

-- 
Author: VIVEK_SHARMA
  INET: vivek_sharma_at_inf.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



*******************************************************************************
The information in this Internet e-mail is confidential and may be legally privileged. It is intended solely for the addressee. Access to this Internet e-mail by anyone else is unauthorised and any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this Internet e-mail are subject to the terms and conditions expressed in any applicable documentation or market practices governing the relationship between Garban Intercapital plc and its clients. Any views expressed in this message are those of the individual sender except where they are stated to be the views of Garban Intercapital plc.
*******************************************************************************
Received on Tue Aug 08 2000 - 04:33:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US