HPE Community
Operating System - HP-UX
1751720 Members
5669 Online
108781 Solutions
New Discussion юеВ

Re: import just sequences (oracle)

 
SOLVED
Go to solution
Roberto Martinez_2
Frequent Advisor

тАО10-29-2002 12:46 AM

тАО10-29-2002 12:46 AM

import just sequences (oracle)

I'd like to know if there's the possibility of importing just the sequences of an oracle .dmp export file. Thanks in advance.
0 Kudos
Reply
2 REPLIES 2
John Palmer
Honored Contributor

тАО10-29-2002 01:12 AM

тАО10-29-2002 01:12 AM

Solution

Re: import just sequences (oracle)

Hi,

Not with import I believe but you can do the following...

grep "CREATE SEQUENCE" > temp.sql

vi temp.sql
%s/"//g
%s/$/;/
:wq

temp.sql will now contain all the relevant CREATE SEQUENCE statements, just run it from sqlplus.

Regards,
John
Reply
Roberto Martinez_2
Frequent Advisor

тАО10-29-2002 01:22 AM

тАО10-29-2002 01:22 AM

Re: import just sequences (oracle)

Great. Just what I needed. Thanx
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.