RE: Interview Question

From: <ramakrishna.gv_at_db.com>
Date: Wed, 27 Sep 2000 14:26:26 +0530
Message-Id: <10632.117964@fatcity.com>

--0__=AJzhsut915a9Rt7Sh9ps85p6bEm7Dw6ZIR2XLwrFEDmYZE84luNLoeKU Content-type: text/plain; charset=us-ascii Content-Disposition: inline

If it is full database import u donot need to create. If it is the user import then it will import into default tablespace of the user.

Thanks & Regards

Ram
Tel:4236953

Message History ----------------------------------------

From: Jahangir_Shaik_at_satyam.com on 27/09/2000 08:47 GMT

Please respond to ORACLE-L_at_fatcity.com

To: ORACLE-L_at_fatcity.com
cc:
Subject: RE: Interview Question

Yes You have to create the same tablespace. Shaik.Jahangir Basha

> ----------
> From: Sandeep Kurliye[SMTP:Sandeep.Kurliye_at_almarai.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Wednesday, September 27, 2000 11:55 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Interview Question
>
> Hi All,
>
> Here is one interview question.
>
> You have taken full export and now importing to new database. Do I have to
> create the same tablespaces (which I was having in original database)
> before
> importing or full import will take care of it???
>
> TIA,
>
> Sandeep.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sandeep Kurliye
> INET: Sandeep.Kurliye_at_almarai.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

--0__=AJzhsut915a9Rt7Sh9ps85p6bEm7Dw6ZIR2XLwrFEDmYZE84luNLoeKU Content-type: text/html;

name="att1.htm"

Content-Disposition: attachment; filename="att1.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDMuMi8vRU4iPg0KPEhUTUw+ DQo8SEVBRD4NCjxNRVRBIEhUVFAtRVFVSVY9IkNvbnRlbnQtVHlwZSIgQ09OVEVOVD0idGV4dC9o dG1sOyBjaGFyc2V0PXVzLWFzY2lpIj4NCjxNRVRBIE5BTUU9IkdlbmVyYXRvciIgQ09OVEVOVD0i TVMgRXhjaGFuZ2UgU2VydmVyIHZlcnNpb24gNS41LjI2NTAuMTIiPg0KPFRJVExFPlJFOiBJbnRl cnZpZXcgUXVlc3Rpb248L1RJVExFPg0KPC9IRUFEPg0KPEJPRFk+DQoNCjxQPjxGT05UIENPTE9S PSIjMDAwMEZGIiBTSVpFPTIgRkFDRT0iQXJpYWwiPlllcyBZb3UgaGF2ZSB0byBjcmVhdGUgdGhl IHNhbWUgdGFibGVzcGFjZS48L0ZPTlQ+DQo8QlI+PEZPTlQgQ09MT1I9IiMwMDAwODAiIFNJWkU9 MiBGQUNFPSJNUyBTYW5zIFNlcmlmIj5TaGFpay5KYWhhbmdpciBCYXNoYTwvRk9OVD4NCjwvUD4N CjxCUj4NCjxVTD4NCjxQPjxGT05UIFNJWkU9MSBGQUNFPSJNUyBTYW5zIFNlcmlmIj4tLS0tLS0t LS0tPC9GT05UPg0KPEJSPjxCPjxGT05UIFNJWkU9MSBGQUNFPSJNUyBTYW5zIFNlcmlmIj5Gcm9t OjwvRk9OVD48L0I+ICZuYnNwOyA8Rk9OVCBTSVpFPTEgRkFDRT0iTVMgU2FucyBTZXJpZiI+U2Fu ZGVlcCBLdXJsaXllW1NNVFA6U2FuZGVlcC5LdXJsaXllQGFsbWFyYWkuY29tXTwvRk9OVD4NCjxC Uj48Qj48Rk9OVCBTSVpFPTEgRkFDRT0iTVMgU2FucyBTZXJpZiI+UmVwbHkgVG86PC9GT05UPjwv Qj4gJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IDxGT05UIFNJWkU9MSBGQUNFPSJNUyBT YW5zIFNlcmlmIj5PUkFDTEUtTEBmYXRjaXR5LmNvbTwvRk9OVD4NCjxCUj48Qj48Rk9OVCBTSVpF PTEgRkFDRT0iTVMgU2FucyBTZXJpZiI+U2VudDo8L0ZPTlQ+PC9CPiAmbmJzcDsgPEZPTlQgU0la RT0xIEZBQ0U9Ik1TIFNhbnMgU2VyaWYiPldlZG5lc2RheSwgU2VwdGVtYmVyIDI3LCAyMDAwIDEx OjU1IEFNPC9GT05UPg0KPEJSPjxCPjxGT05UIFNJWkU9MSBGQUNFPSJNUyBTYW5zIFNlcmlmIj5U bzo8L0ZPTlQ+PC9CPiAmbmJzcDsmbmJzcDsmbmJzcDsgPEZPTlQgU0laRT0xIEZBQ0U9Ik1TIFNh bnMgU2VyaWYiPk11bHRpcGxlIHJlY2lwaWVudHMgb2YgbGlzdCBPUkFDTEUtTDwvRk9OVD4NCjxC Uj48Qj48Rk9OVCBTSVpFPTEgRkFDRT0iTVMgU2FucyBTZXJpZiI+U3ViamVjdDo8L0ZPTlQ+PC9C PiAmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgPEZPTlQgU0laRT0xIEZBQ0U9 Ik1TIFNhbnMgU2VyaWYiPkludGVydmlldyBRdWVzdGlvbjwvRk9OVD4NCjwvUD4NCg0KPFA+PEZP TlQgU0laRT0yIEZBQ0U9IkFyaWFsIj5IaSBBbGwsPC9GT05UPg0KPC9QPg0KDQo8UD48Rk9OVCBT SVpFPTIgRkFDRT0iQXJpYWwiPkhlcmUgaXMgb25lIGludGVydmlldyBxdWVzdGlvbi48L0ZPTlQ+ DQo8L1A+DQoNCjxQPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+WW91IGhhdmUgdGFrZW4gZnVs bCBleHBvcnQgYW5kIG5vdyBpbXBvcnRpbmcgdG8gbmV3IGRhdGFiYXNlLiBEbyBJIGhhdmUgdG88 L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj5jcmVhdGUgdGhlIHNhbWUgdGFi bGVzcGFjZXMgKHdoaWNoIEkgd2FzIGhhdmluZyBpbiBvcmlnaW5hbCBkYXRhYmFzZSkgYmVmb3Jl PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+aW1wb3J0aW5nIG9yIGZ1bGwg aW1wb3J0IHdpbGwgdGFrZSBjYXJlIG9mIGl0Pz8/PC9GT05UPg0KPC9QPg0KDQo8UD48Rk9OVCBT SVpFPTIgRkFDRT0iQXJpYWwiPlRJQSw8L0ZPTlQ+DQo8L1A+DQoNCjxQPjxGT05UIFNJWkU9MiBG QUNFPSJBcmlhbCI+U2FuZGVlcC48L0ZPTlQ+DQo8L1A+DQoNCjxQPjxGT05UIFNJWkU9MiBGQUNF PSJBcmlhbCI+LS0gPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+UGxlYXNl IHNlZSB0aGUgb2ZmaWNpYWwgT1JBQ0xFLUwgRkFROjwvRk9OVD48VT4gPEZPTlQgQ09MT1I9IiMw MDAwRkYiIFNJWkU9MiBGQUNFPSJBcmlhbCI+PEEgSFJFRj0iaHR0cDovL3d3dy5vcmFmYXEuY29t IiBUQVJHRVQ9Il9ibGFuayI+aHR0cDovL3d3dy5vcmFmYXEuY29tPC9BPjwvRk9OVD48L1U+DQo8 QlI+PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj4tLSA8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0y IEZBQ0U9IkFyaWFsIj5BdXRob3I6IFNhbmRlZXAgS3VybGl5ZTwvRk9OVD4NCjxCUj48Rk9OVCBT SVpFPTIgRkFDRT0iQXJpYWwiPiZuYnNwOyBJTkVUOiBTYW5kZWVwLkt1cmxpeWVAYWxtYXJhaS5j b208L0ZPTlQ+DQo8L1A+DQoNCjxQPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+RmF0IENpdHkg TmV0d29yayBTZXJ2aWNlcyZuYnNwOyZuYnNwOyZuYnNwOyAtLSAoODU4KSA1MzgtNTA1MSZuYnNw OyBGQVg6ICg4NTgpIDUzOC01MDUxPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlh bCI+U2FuIERpZWdvLCBDYWxpZm9ybmlhJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i c3A7Jm5ic3A7IC0tIFB1YmxpYyBJbnRlcm5ldCBhY2Nlc3MgLyBNYWlsaW5nIExpc3RzPC9GT05U Pg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS08L0ZPTlQ+DQo8QlI+ PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj5UbyBSRU1PVkUgeW91cnNlbGYgZnJvbSB0aGlzIG1h aWxpbmcgbGlzdCwgc2VuZCBhbiBFLU1haWwgbWVzc2FnZTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpF PTIgRkFDRT0iQXJpYWwiPnRvOiBMaXN0R3VydUBmYXRjaXR5LmNvbSAobm90ZSBFWEFDVCBzcGVs bGluZyBvZiAnTGlzdEd1cnUnKSBhbmQgaW48L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yIEZBQ0U9 IkFyaWFsIj50aGUgbWVzc2FnZSBCT0RZLCBpbmNsdWRlIGEgbGluZSBjb250YWluaW5nOiBVTlNV QiBPUkFDTEUtTDwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPihvciB0aGUg bmFtZSBvZiBtYWlsaW5nIGxpc3QgeW91IHdhbnQgdG8gYmUgcmVtb3ZlZCBmcm9tKS4mbmJzcDsg WW91IG1heTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPmFsc28gc2VuZCB0 aGUgSEVMUCBjb21tYW5kIGZvciBvdGhlciBpbmZvcm1hdGlvbiAobGlrZSBzdWJzY3JpYmluZyku Received on Wed Sep 27 2000 - 03:56:26 CDT