How to export "Sql Proiles" from one database and import into another (10g R2)

Posted on 2006-03-24
Medium Priority
Last Modified: 2011-10-03
I need to know how to export Sql Profiles created in one instance and import them into another.
Can I simply export the dba_sql_profiles table and import into the other?

Question by:strongs120
1 Comment
LVL 35

Accepted Solution

johnsone earned 2000 total points
ID: 16281844
I do not have a copy of 10g to confirm this with, but based on the name DBA_SQL_PROFILES is a view, not a table.  There would be at least one underlying table of that view.

Oracle does not support export/import on dictionary tables.  You will have to come up with some SQL on your own to use the DBA_SQL_PROFILES to regenerate the create statements.

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows how to recover a database from a user managed backup
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses
Course of the Month16 days, 23 hours left to enroll

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question