Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

import just sequences (oracle)

SOLVED
Go to solution
Roberto Martinez_2
Frequent Advisor

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.
2 REPLIES
John Palmer
Honored Contributor
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
Roberto Martinez_2
Frequent Advisor

Re: import just sequences (oracle)

Great. Just what I needed. Thanx