473,943 Members | 4,291 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Copy schema without data

Sorry for the sender name, just set up my news account...
Hi all

Probably an easy question for an oracle dba or even power user:

I would like to copy the data warehouse schema on my laptop for testing and
developing our application.
- Unfortunately I have a 80GB HD and the DWH contains a few 'tera'.
- Fortunately, I don't need the data (ok perhaps a few master data). I need
only the schema to avoid 'table not found' errors and so on.

How can I copy all the tables (mat. views to be correct) without the data
from our dwh? But please don't tell me to dump the whole thing and delete
the data. DWH and networking team would kill me.

Good news: no indices, no constraints, just 1 to 1 raw data dumped out of
our business solution environment. But I only have access to mat. views and
not to the tables directly.

I tried a create table from select... that did the job more or less but I
guess I can't trust it (do mat views identify their underlaying schema
correctly?)

Forgive a spoiled ms developer and thank you in advance

Raoul

Aug 26 '08 #1
1 9279
"Raoul Minder" <ra***@nospam.m inder.namewrote in
news:5a******** *************** ****@news.cyber link.ch:
Sorry for the sender name, just set up my news account...
Hi all

Probably an easy question for an oracle dba or even power user:

I would like to copy the data warehouse schema on my laptop for
testing and developing our application.
- Unfortunately I have a 80GB HD and the DWH contains a few 'tera'.
- Fortunately, I don't need the data (ok perhaps a few master data). I
need only the schema to avoid 'table not found' errors and so on.

How can I copy all the tables (mat. views to be correct) without the
data from our dwh? But please don't tell me to dump the whole thing
and delete the data. DWH and networking team would kill me.

Good news: no indices, no constraints, just 1 to 1 raw data dumped out
of our business solution environment. But I only have access to mat.
views and not to the tables directly.

I tried a create table from select... that did the job more or less
but I guess I can't trust it (do mat views identify their underlaying
schema correctly?)

Forgive a spoiled ms developer and thank you in advance

Raoul

use export/import [exp/imp]
You can use ROWS=NO on either utility
Therefore you can get all the objects without any data;
very small footprint.
Aug 28 '08 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

42
5835
by: Edward Diener | last post by:
Coming from the C++ world I can not understand the reason why copy constructors are not used in the .NET framework. A copy constructor creates an object from a copy of another object of the same kind. It sounds simple but evidently .NET has difficulty with this concept for some reason. I do understand that .NET objects are created on the GC heap but that doesn't mean that they couldn't be copied from another object of the same kind when...
0
1224
by: vojtech | last post by:
Hi, I would like to remark on a problem described by Stephen Livesey almost 3 years ago, about the slowdown he had experienced with an upload of several millions of rows. http://www.geocrawler.com/mail/thread.php3?subject=%5BGENERAL%5D+Slowdown+problem+when+writing+1.7million+records&list=12
6
2605
by: Martin | last post by:
Hi, I have a xml file like the one below <?xml version="1.0" encoding="utf-8"?><e1 xmlns:e1="http://tempuri.org/Source1.xsd" e1:att1="1" e1:att2="2" e1:rest="345"/> If I try to create a schema for it with Visual Studio, I get the error "Failed to create a schema for this data file because:
4
1890
by: Sindarian | last post by:
This just seems like the most basic thing, but I can't find a simple description of this process anywhere and in here, everone is talking about going the other way :( I had .NET create an XML Schema file (xsd) for a table in my database. I then create a DataSet that contains 1 row of data from that same table. I want to use this DataSet along with the Schema file to create an XML file that ACTUALLY CONTAINS THE DATA. Simple huh: DataSet +...
2
2682
by: Janning Vygen | last post by:
hi PGurus, i searched the archives and read the docs, because this problem shouldn't be new. But i really don't know what to search for. i am populating a database (v7.4.1) with COPY. Some triggers in the db schema fire on inserts and do some additional data manipulations, which i dont want to take place by running COPY because my data don't need those additional manipulation. Therefor and for performance reasons, i disable all...
1
3550
by: Rachel McConnell | last post by:
Hi, I am trying to import data using COPY, from a file containing thirty or so COPY commands each with 0 or more rows of data. Reason, I have a small data set I want to include into a database with an identical schema, with existing data. I figured a good way to do this would be to use pg_dump on the small dataset, trim out the table definitions and constraints, and run the resulting file. (I also reordered the COPY statements to...
1
1857
by: okonita | last post by:
Hi all, I have a need to copy data from one database/schema to a different database schema. Yes, I can use export/import but that is not "elegant". Yes, I can try a redirected Restore from Backup but this method has the irritating requirement of pause, set tablespaces and continue, again much manual intervention. What I am most interested in is this: The two databases are in the same instance/server. I want to be able to copy directly from...
1
1615
by: news.magnet.ch | last post by:
Hi all Probably an easy question for an oracle dba or even power user: I would like to copy the data warehouse schema on my laptop for testing and developing our application. - Unfortunately I have a 80GB HD and the DWH contains a few 'tera'. - Fortunately, I don't need the data (ok perhaps a few master data). I need only the schema to avoid 'table not found' errors and so on.
2
21619
by: Dev guy | last post by:
Hi all is there a simple command where I can just copy some data from one database server to another? For example, lets say i have two servers that have the same table called "States" If I have all the state names in server1 but want to copy the all the data to Server2, how would I write a command for this? INSERT INTO ..states
0
10143
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9970
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
11304
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9866
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
8232
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6090
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4914
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4515
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3516
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.