sql - How best can I recreate an Oracle database? -

-

Oracle 11 GR2 (x86 Windows):

I have a DB with 250 tablets with indexes and constraints I

I need to re-create these tables, indexes and hurdles in new db and load the data. I need to know how to do the following in SQL Plus and / or SQL Developers, unless this is a magical utility that can automate all this. thank you in advanced!

  1. Unload all data from 250 tables.

  2. Create a SQL script file containing the create table statement for 250 tables.

  3. Create a SQL scripts file containing the CREATE INDEX statement for 250 tables

  4. < P> Create a SQL script file containing the ALTER TABLE ADD CONSTRIENCE statement for 250 tables.

  5. Run the script to create tables in the new DB.

  6. Load the exported data in the table in the new DB.

  7. Run the script to make all indexes.

  8. Run the script to add all the controls.

    Edit: I am connected to a remote desktop that links to source db on a Windows Server 2008. Only one Oracle client is installed in the remote. For security reasons, I do not have permission to link directly to the Win Server from my local computer, so I can dump the whole source db on the remote to zip on my local target machine? I'm trying to replicate the whole DB on my computer, starting with Oracle 10G, you can use expdb and

    "command line Use the procedures given in the DBMS_ DATAPUMP PL / SQL package. " (excerpted from the documentation of Oracle)

    Looking at your needs, you have to create a directory, then generate a full dump of your code expdb : 

      SQL & gt; Create or change '/ path / to / dump / folder' as the directory dump_rate;   
      sh $ expdp system @ db10g full = y directory = DUMP_DIR dumpfile = db.dmp logfile = db.log   
     forms of dumps Written using some binary format, you have to use related import utility to import related debits. Originally replacing  expdb  with  impdb  in the above command:  
      sh $ impdp system @ db10g complete = y directory = DUMP_DIR Dumpfile = db For a simple table dump, use that version instead:  
      sh $ expdp sylvain @ db10g tables = DEPT, DP logfile = db.log   
     
     EMP directory = DUMP_DIR dumpfile = db.dmp logfile = db.log   
     As you have seen, you can use it from your standard user account, provided you For detailed usage clarification, see 
       
    • .

Comments

Post a Comment

Popular posts from this blog

java - ImportError: No module named py4j.java_gateway -

-
I'm trying to call the Python using the Java program py4j . I've been installing the plug-in Eclipse and test name Piidvi project. I'm trying to execute the following part of the code found on py4j webpage: Import from py4j.java_gateway to JavaGateway, java_import gateway = JavaGateway () jvm = gateway.jvm java_import (jvm, '' Org.eclipse Kkorkrisorsej. * ") Vrkspes_rut = Jvankresourkesplginkgetvrkspas (). GetRoot (Gateway .help (workspace_root, '* Projects *') project_names = [project.getName () (for projects workpace_root.getProjects))] print (Projekt_nam) But I There is an error in import. I have checked that the P4JJ is present in the Jar Eclipse plugin directory. Can anyone help please? I had to install the py4j application
Read more

python - Receiving "KeyError" after decoding json result from url -

-
I am new to Python I am trying to parse JSON result from a URL. Basically, I was using the following: response = urllib.request.urlopen (url) json_obj = json.load (response) It should be a stroke "str 'not' bytes' in the lines of a given" JSON object, so after searching on the StackoverView Flo, I decode the response in this way: F = urllib.request.urlopen (Url) charset = f.info (). Get_param ('charset', 'utf8') data = f.read () decoded = json.loads (data.decode (charset)) If I print "decode" I is as follows: { 'link': { 'summary data': 'https: // localhost / piwebapi / streams / p0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTExNQU42NDIwXFNJTlVTT0lE / summary' 'value': 'https: // localhost / Piwebapi / streams / P0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTExNQU42NDIwXFNJTlVTT0lE / price ',' InterpolatedData ':' https: // localhost / Piwebapi / streams / P0_7qHaW4UHU-RlCaz8tpasAAQAAAAU0hJTE...
Read more

.net - Creating a new Queue Manager and Queue in Websphere MQ (using C#) -

-
"itemprop =" text "> I am writing applications that use WebSphere MQ to send messages. My unittests (for flow), I want to verify that I have put the correct message on the response queue. I am trying to figure out how to do this. My main obstacle is that I think it might be scary to clear the queue before running in my queue because the same queue can be used by other applications, I thought a decent solution would be a new line The manager will remove the queue for my solidarity and after using it. So my question is: Is it possible to use C # by using queue manager and queue? After the For future reference and future people, who want to make queues. I thought how to make and remove IBM MQ QE (not quenhers) with PCM messaging. It is not very simple, but it can be done. We have implemented it in a library and it is being used to create and delete commands before and after integration tests. The most important part of the code in this library is shown in the...
Read more