oracle11g - SYSTEM tables import into other schema in oracle 11g -


i trying take oracle db backup using expdp. have specific case application table resides in system tablespace.

  1. the backup export of schema created options schemas=system , include=table:"like 'user%'" corresponds application tables.
  2. i have created schema user impexp has different tablespace allocated it. when try import .dmp file impexp, import unsuccessful stating "system"."user_sys_mast" exists. there way import table in newly created schema. tried using option remap_schema=system:impexp, seems error out saying ora-39013: remapping system schema not supported.

summarizing : want import application tables in system tablespace new tablespace 'impexp'.

please let me know if going wrong somewhere , trying isn't supported.

any appreciated.

this 1 of reasons why putting application tables in sys or system schemas considered bad practice. these schemas vital running of our databases , should not meddled with.

you have compounded bloomer naming tables prefix of user, same convention data dictionary uses.

what need create new schema hold these tables. grant whatever privileges needs made think had owned system. move tables out of system schema.

to proper job should change application use new schema, temporary fix give system rights on tables , build synonyms them. if have time, change application. cause less grief in long run.

either way, able export data out of old database , target database using new schema.


Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more