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: do not want to import procedures view, etc

RE: do not want to import procedures view, etc

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 17 Feb 2004 11:23:59 -0500
Message-ID: <564DE4477544D411AD2C00508BDF0B6A1CE0A9F6@USAHM018.amer.corp.eds.com>


Warning, there used to be a 99 table name limit in the tables= parameter. I do not know what the current limit is for version 9+, but I would not rely on the length of the list being unlimited so you may want to test. It would be nice if you responded back with the test results.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Freeman, Donald Sent: Tuesday, February 17, 2004 9:43 AM To: oracle-l_at_freelists.org
Subject: RE: do not want to import procedures view, etc

I would do a table level import only and write a create script for my = parfile. You're going to have a big parfile but I don't see why you = can't do it.

SET ECHO OFF
SET head OFF
SET feedback OFF
SET NEWPAGE 0
SET SKIP 0 SPOOL parfile.txt
prompt FROMUSER=3Dwhoever
prompt TOUSER=3Dwhoever
prompt FILE=3Dexport.dmp
prompt LOG=3Dimport.log
prompt ROWS=3Dy
prompt IGNORE=3DY
prompt INDEXES=3DN
prompt CONSTRAINTS=3DN
prompt GRANTS=3DN
prompt ANALYZE=3DN
prompt RECALCULATE_STATISTICS=3DY
prompt TABLES=3D(
SELECT name||',' FROM dba_tables where owner =3D'SCHEMA_OWNER; prompt )

SPOOL OFF
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of George Leonard Sent: Tuesday, February 17, 2004 6:56 AM To: oracle-l_at_freelists.org
Subject: do not want to import procedures view, etc

Hi all
I am about to refresh a system from a production system, but ONLY want to do the data,

Don't want to update any materialized views, normal views, procedures, functions, packages.

Basically only want to truncate the current table and refresh the data.

About 20 000 tables in 30 schemas.

Any idea.

Currently looking at exp/imp but this will also do views and procedures etc...

George
=20



=20
George Leonard
Oracle Database Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Tel: (+27 11) 575 0573
Fax: (+27 11) 576 0573
E-mail:george.leonard_at_za.didata.com
Web: http://www.didata.co.za
=20
You Have The Obligation to Inform One Honestly of the risk, And As a Person
You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed & Totally Aware of the Risk,=20 Every Fool Has the Right to Kill or Injure Themselves as They See Fit! =20

"This e-mail is sent on the Terms and Conditions that can be accessed by = Clicking on this link http://www.vodacom.net/legal/email.asp "



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Tue Feb 17 2004 - 10:23:59 CST

Original text of this message

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