HPE Community
Operating System - HP-UX
1752782 Members
5848 Online
108789 Solutions
New Discussion юеВ

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.