Current Position:Home > datapump frpm schema to schema

datapump frpm schema to schema

Advertisement
  • Whats the quickest way to export packages,tables etc from one enviroment Updated:12-08

    Hi whats the quickest way of more loads of packages, tables, indexes etc. from one enviroment to another? I did some things in apex.oracle.com workspace to test apex now I want to move it across to my xe installation.Hello, 2 'fast' options really -

  • Datapump - expdp.open creates tables in schema Updated:11-30

    Hi      i am using datapump in Oracle 10g to archive old partitions from the main schema to another schema. i notice that when dbms_datapump.open is called that a new table is created by dbms_datadpump for internal purposes. This is verified in the o

  • Exporting schema from 11.1.0.7 to 10.2.0.4 Updated:10-11

    I am working on Oracle Database version 11.1.0.7 on Solaris 10. I need to export a schema from this version and import into 10.2.0.4 version i Windows 2003. So should I install 10.2.0.4 client on Solaris and run exp to create a 10.2.0.4 dump file. Sh

  • Data pump import a table in to a different schema in 11g Updated:10-11

    Hi All I have 11.2 Oracle database and i have a requirement to import few tables in to a new schema using my previous month export. I can not import whole schema as it is very large. I check REMAP_TABLE option but it just create the table in same sch

  • Can I recover one schema from Rman Backup Updated:10-11

    hi experts, I have Raman backup of my database and database is in archivelog mod. by mistake all data is deleted from one of schema. I dont want to change anything in other schemas. Can I recover my data ? O.S. = SunOS 5.10 oracle = 10.2.0.3.0As far

  • Different ways to copy data between two schemas in one instance Updated:10-11

    Hi there, I am searching a good way to copy data between two schemas in the same instance. Both schemas have an identical structure such as triggers, tables, views and so on. The only difference is the purpose: one is the productivity system and one

  • How to export user/schema WMSYS Updated:10-11

    Trying to export WMSYS using datapump. Output is shown below. Need help.... Schema is present and has procedure/functions/types [encripted]/tables etc. C:\>expdp [email protected] directory=data_pump_dir dumpfile=wmsys.dmp logfile=wmsys.log schemas=wmsys E

  • Schema Export using DBMS_DATAPUMP is extremely slow Updated:10-11

    Hi, I created a procedure that duplicates a schema within a given database by first exporting the schema to a dump file using DBMS_DATAPUMP and then imports the same file (can't use network link because it fails most of the time). My problem is that