Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Moving a stored procedure
I am covering for our DBA who is on vacation - sorry if question seems
dumb. I remember that
SELECT *
FROM sys.dba_source
WHERE type = 'PROCEDURE'
lists all the stored procedures in a database. But somone once showed me simple command to move stored procedure from a test database to production database (8i) inside sqlplus - I just can't remmber. Can anyone help?